Calculated column in Matrix

[carlm1975]

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

I 

[v-yuta-msft · Accepted solution]

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