Measure: Reseller Total Sales - Sales Territory sliced by Employee

CollapseAll image

Collapse image Measure properties


 Property   Value 
 Format    
 Format string   '\$#,0.00;(\$#,0.00);\$#,0.00' 
 Measure type   User 
 Is default field set   False 

Collapse image 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]));

Collapse image See also


About this documentation