Measure: Reseller Total Sales - Sales Territory sliced by Reseller

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 Reseller]=CALCULATE(SUM('Reseller Sales'[Sales Amount]), USERELATIONSHIP(Reseller[ResellerKey], 'Reseller Sales'[ResellerKey]), USERELATIONSHIP(Geography[GeographyKey], Reseller[GeographyKey]), USERELATIONSHIP('Sales Territory'[SalesTerritoryKey], Geography[SalesTerritoryKey]));

Collapse image See also


About this documentation