Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |