Skip to main content
cancel
Showing results for
Search instead 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?

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
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.

## Helpful resources

Announcements

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors