Calculating category wise % using Total

[NidhiBhusari]

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 selected age category should get displayed.

Age Group	No of Voters
21-30	100000
31-40	345000
41-50	545000
51-65	7500000
66-80	200000

[amitchandak · Accepted solution]

@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 · Accepted solution]

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.

[amitchandak · Accepted solution]

@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)))