Measure: Reseller Total Sales - Sales Territory sliced by Employee
Measure properties
| Property | Value |
| Format | |
| Format string | '\$#,0.00;(\$#,0.00);\$#,0.00' |
| Measure type | User |
| Is default field set | False |
Command
---------------------------------------------------------- -- 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])); |
See also