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

Hi Mart,

 

You could use the DAX below.

Measure = sum(Table2[Amount])/CALCULATE(SUM(Table2[Amount]),ALLEXCEPT(Table2,Table2[Group]))

Sample data

 

Regards,

Charlie Liao

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

Charlie

 

Thats ecactly what I want, but I cant repeate it I will start again from scratch.

Could it be because I have it in a matrix?

 

Mart

  • 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?