Forum Discussion
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
I
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
1 Reply
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