cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Percentage of row total going over 100%

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

8 REPLIES 8
Regular Visitor

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?

New Member

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

Super User

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?

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Frequent Visitor

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
Not applicable

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

Frequent Visitor

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

Resolver I

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
Not applicable

Hi @tom_,

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.