Individual percentage is showing more than TOTAL in Table visual

[HemanthV]

Hello Guys,

When i manually add all the bars, the percentage is getting more than the total. The total is correct but the bar percentages are wrong. Please help me on this.

I will paste the internal measure below:

Service Level Cut % - Region = DIVIDE( SUM(data[otif_net_order_gsv])-SUM(data[otif_gsv]), CALCULATE(SUM(data[otif_net_order_gsv]),ALLSELECTED(data[gpp_sbu],data[Material Code])))

Please find the attached file for referrence:
https://drive.google.com/file/d/1t2Efghsxn2a6yT2iKq7yQ6yLETcE_ayi/view?usp=sharing

Thanks in advance!

[v-jingzhang]

Hi @HemanthV 

Sorry I don't understand what your measures want to calculate. Can you forget about them and explain what you hope to achieve in the table visual? What should be the numerator and denominator on each row and on total?

Regards,
Community Support Team _ Jing

[Greg_Deckler · Accepted solution]

@HemanthV This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[HemanthV]

Hi @Greg_Deckler ,

In my case the problem is not with my totals. The total is correct that is 55.9%, but my bars need to segregate for this 55.9%. 
I have a card which shows 44.01% the remaining percentage we are showing in bar chart, so the total is right that is 55.99% but the bar percentages are wrong. I think the filter context needs to be changed for the measure. I am stuck at this point.