Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

100%

    Hi guys,    as you can see in the first picture, i see 100% with Country All.  Now, i want to see only austria and austria is 329.363 from 12.464917 units, 2.64% of 100% But i wan...
talespin's avatar
talespin
Icon for Solution Sage rankSolution Sage
2 years ago

hi Anonymous ,

 

Please replace table and column names with yours.

Measure

PctOfTotal =
VAR _TotSales = CALCULATE(SUM(TestTbl1[Sales]), ALLSELECTED(TestTbl1[Country]), ALLSELECTED(TestTbl1[Region]))
VAR _CountryRegionSales = CALCULATE(SUM(TestTbl1[Sales]))

RETURN DIVIDE(_CountryRegionSales, _TotSales, BLANK())