Forum Discussion

Mart's avatar
Mart
Icon for Advocate IV rankAdvocate IV
9 years ago

Pecentage in a matrix with grouping Help

using this: percent = DIVIDE(SUM('Table1 (2)'[People]), CALCULATE(COUNT('Table1 (2)'[People]),ALLEXCEPT('Table1 (2)','Table1 (2)'[People])))   I was able to get a percentage but the calculation ne...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Mart, Could you please provide us more information why you cannot do it? If possible providue us some screenshot, so that we can make further analysis.

 

Regards,

Charlie Liao

Mart's avatar
Mart
Icon for Advocate IV rankAdvocate IV
9 years ago

Cracked it! At least I have the correct numbers


I used 3 new measures

First New Measure

GrandTotal = CALCULATE(SUM(Table2[People]),GROUPBY(Table2,Table2[Group]),ALLEXCEPT(Table2,Table2[Year],Table2[People]))

Second New Measure

PeopleSum = SUM(Table2[People])

Third New Measure

Percent = Table2[PeopleSum]/Table2[GrandTotal]


Question

Is there an easier way?