Percentage of row total going over 100%

[Tom_]

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

[Anonymous]

I have a gantt chart and a column named completed percent limited where the values range between 0 to 100. But when I plot a gantt chart by adding the completed percent limited column to tooltip, I can see that the values exceed 100. Can someone explain me how to resolve this issue?

[Anonymous]

Hi, did you ever find a solution for this? I'm facing the same issue. Thanks!

[Greg_Deckler]

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?

[Tom_]

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

[Anonymous]

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

[Tom_]

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

[rjs2]

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% 

[Anonymous]

Hi @tom_,

This looks like a rounding issue. I would change the number of decimals in the format pane of the visual.