Forum Discussion
wrong totals in table while percentages
while calculating the percentages the values of categories are correct but the total of the percentages are wrong
hello powanpilla for each measure that has wrong percentage , do the following measure
if(hasonevalue('table'[fruits]) , [your measure] , sumx(values('table'[fruits]),[your measure]))
do this for each incorrect total measure and put the new measure
5 Replies
- Greg_Deckler
Community Champion
powanpilla First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
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
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
eliasayyy please Help
eliasayyyMemorable Member
hello powanpilla for each measure that has wrong percentage , do the following measure
if(hasonevalue('table'[fruits]) , [your measure] , sumx(values('table'[fruits]),[your measure]))
do this for each incorrect total measure and put the new measure- Ashish_Mathur
Super User
How have you calculate those pecentahes at the catgory level? Share the download link of the PBI file and show the expected result very clearly.
