Measure: Reseller Total Sales - Sales Territory sliced by Reseller
Property | Value |
Format | |
Format string | '\$#,0.00;(\$#,0.00);\$#,0.00' |
Measure type | User |
Is default field set | False |
---------------------------------------------------------- -- PowerPivot measures command (do not modify manually) -- ---------------------------------------------------------- CREATE MEASURE 'Reseller Sales'[Reseller Total Sales - Sales Territory sliced by Reseller]=CALCULATE(SUM('Reseller Sales'[Sales Amount]), USERELATIONSHIP(Reseller[ResellerKey], 'Reseller Sales'[ResellerKey]), USERELATIONSHIP(Geography[GeographyKey], Reseller[GeographyKey]), USERELATIONSHIP('Sales Territory'[SalesTerritoryKey], Geography[SalesTerritoryKey])); |