Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix Grouping

Hi, how do you do a percentage off of two fields in the matrix grouping? In this example, you see the totals here and I'm looking to do a [data changes] / [assessments administered] but every formul...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

    Based on what I've gotten, it seems to add up all the calculated percentages to get the total.

    Please try using a measure like this:

    Measure =
DIVIDE ( SUM ( [Data Changes] ), SUM ( [Assessments Administered] ) )

     

    If it doesn't work, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.

     

     

    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
4 years ago

Hi, Anonymous 

Based on what I've gotten, it seems to add up all the calculated percentages to get the total.

Please try using a measure like this:

Measure =
DIVIDE ( SUM ( [Data Changes] ), SUM ( [Assessments Administered] ) )

 

If it doesn't work, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.

 

 

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks so much  _ Zeon Zheng! It was the answer to my question and because of it i was able to finally take my complete my report and hand it over to validation!  You are my hero!