table OrgMappingGeo lineageTag: d6e7d9a4-2717-4f4d-a4fd-22ff8d95ac51 calculationGroup precedence: 2 calculationItem OrgGeo = ``` // IF( // ISFILTERED ( Dim_Org ), // CALCULATE ( // SELECTEDMEASURE (), // USERELATIONSHIP(Dim_RC[AUDIT_SOURCE],Dim_GeoKey[AUDIT_SOURCE]) // ), SELECTEDMEASURE () // ) // IF( // ISFILTERED ( Dim_Org ), // CALCULATE ( // SELECTEDMEASURE (), // TREATAS( VALUES( Dim_Org[AUDIT_SOURCE]), Dim_GeoKey[AUDIT_SOURCE] ) // ), // SELECTEDMEASURE () // ) // SWITCH( TRUE() , // ISFILTERED ( Dim_Org ) && ISFILTERED(Dim_CoreDept), // CALCULATE ( // SELECTEDMEASURE (), // TREATAS( VALUES( Dim_Org[AUDIT_SOURCE]), Dim_GeoKey[AUDIT_SOURCE] ), // TREATAS( VALUES( Dim_CoreDept[MKT_SOURCE]), Dim_Market[MKT_SOURCE] ) // ), // ISFILTERED ( Dim_Org ), // CALCULATE ( // SELECTEDMEASURE (), // TREATAS( VALUES( Dim_Org[AUDIT_SOURCE]), Dim_GeoKey[AUDIT_SOURCE] ) // ), // ISFILTERED ( Dim_CoreDept ), // CALCULATE ( // SELECTEDMEASURE (), // TREATAS( VALUES( Dim_CoreDept[MKT_SOURCE]), Dim_Market[MKT_SOURCE] ) // ), // SELECTEDMEASURE () // ) ``` column OrgGeo dataType: string lineageTag: 9db871a1-0e66-4338-8fae-d35cb5a2d8fd summarizeBy: none sourceColumn: Name sortByColumn: 序号 annotation SummarizationSetBy = Automatic column 序号 dataType: int64 formatString: 0 lineageTag: dea2aab2-c283-49ef-b4ab-7a4d367e3364 summarizeBy: sum sourceColumn: Ordinal annotation SummarizationSetBy = Automatic