Forum Discussion

NidhiBhusari's avatar
NidhiBhusari
Helper IV
5 years ago
Solved

Calculating category wise % using Total

Hello, Can anyone guide on how to calculate category wise % contribution using total. Ex - I have age group, no of voters and on selection from slicer of particular age group % of voters in sel...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    NidhiBhusari , based on what I got so far , a measure like

    divide(sum(Table[No of Voters]), calculate(sum(Table[No of Voters]), allselected(Table)))

  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, NidhiBhusari 

     

    Try to create a measure like this:

    Measure = 
var _total=CALCULATE(SUM('Table'[No of Voters]),ALL('Table'))
var _r=CALCULATE(SUM('Table'[No of Voters]))
return DIVIDE(_r,_total)

    Result:

    Please refer to the attachment below for details

     

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
5 years ago

Hi, NidhiBhusari 

 

Try to create a measure like this:

Measure = 
var _total=CALCULATE(SUM('Table'[No of Voters]),ALL('Table'))
var _r=CALCULATE(SUM('Table'[No of Voters]))
return DIVIDE(_r,_total)

Result:

Please refer to the attachment below for details

 

 

Hope this helps.

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.