Measure: Reseller Total Sales - Sales Territory sliced by Employee
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 Employee]=CALCULATE(SUM('Reseller Sales'[Sales Amount]),USERELATIONSHIP(Employee[EmployeeKey],'Reseller Sales'[EmployeeKey]),USERELATIONSHIP('Sales Territory'[SalesTerritoryKey],Employee[SalesTerritoryKey])); |