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.
Hi All,
I'm a bit new to Power Bi and have been struggling to find a way to correct the percentage of row totals going over 100% as in the below matrix:
The table data looks like this, with the value field in the Matrix being set to a count of the "Ticket ID" column one of which is showing the value as a percentage of the row total
Table name is 'Data'
Ticket ID | Date Closed | SLA State |
1 | 05/07/2018 | Within SLA |
2 | 06/07/2018 | Breached SLA |
3 | 07/07/2018 | Breached SLA |
4 | 08/07/2018 | Within SLA |
5 | 09/07/2018 | Within SLA |
Have looked around the forum but unable to find anything that works, any advice would be appreciated
Many Thanks,
Tom
Hi, did you ever find a solution for this? I'm facing the same issue. Thanks!
That looks for all the world like a rounding problem if I understand what you are saying. Try increasing the decimal places to 2 digits?
Thanks for your response, i adjusted the number of decimal places but the percentage totals still don't add up to 100% (i.e. July is 88.95% + 11.72% = 100.67%)
Many Thanks,
Tom
Hi @Tom_,
Hmm, weird. Is the % a self made measure, or did you create it by "show value as: percent of row total"?
If it is a measure, could you share the dax formula?
Koen
Hi Koen,
I was using the "show value as: percent of row total", however I just changed the count (distinct) to a normal count and it all adds up to 100% for some reason. All of the columns were set to Count (Distinct) as there were a few instances where dupes appeared in the data where a case has been reopened.
Many Thanks,
Tom
I can confirm, I ran into the same issue and I was counting distinct values. Once I changed it to just count, it totaled correctly.
I would like to know why distinct count doesnt work with the percent of row function. It doesnt make sense that it will add up to be more than a 100%, and it even displays the total as 100% when its actualy 102.xx%
Hi @tom_,
This looks like a rounding issue. I would change the number of decimals in the format pane of the visual.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |