Forum Discussion

carlm1975's avatar
carlm1975
Frequent Visitor
8 years ago
Solved

Calculated column in Matrix

I have the matrix below, Id like to be able to show rework percent (which is currently being calculated in the SQL) so that the total is correctly shown rather than being a sum. Hope this makes sense...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi carlm1975,

     

    To get the correct total percent, create a measure using DAX like below:

     

    Total Percent =
SUM ( Table[#ReworkReceived] ) / SUM ( Table[#AssessmentsCleared] )

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi carlm1975,

 

To get the correct total percent, create a measure using DAX like below:

 

Total Percent =
SUM ( Table[#ReworkReceived] ) / SUM ( Table[#AssessmentsCleared] )

Regards,

Jimmy Tao