Forum Discussion
Problem with a table totals
Hello
I've been stuck with a total board problem for several days now. The cell values are OK but the total is as if you did not consider the partial calculation of the cell. Considering that I connect with the BBDD dynamically and can't play in power bi, how can I fix it?
Is there a way to tell you through MDX the scope of the calculation or something so that the total is correct? I'm really stuck in this and I'm at the end of development. I need help, please.
Greetings and thank you poe advance.
5 Replies
- Greg_DecklerCommunity Champion
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 - v-xicaiCommunity Support
Hi javitxin42 ,
You may create a measure like DAX below to replace your original measure,
Total Sum= VAR _table = SUMMARIZE('Fact Data',[the first displaying column of your Table visual],"_Value",[your original measure]) RETURN IF(HASONEVALUE([the first displaying column of your Table visual]),[your original measure],SUMX(_table,[_Value]))Refer to cases:
https://community.powerbi.com/t5/Desktop/Maximum-value-and-total-by-group/m-p/727857#M351273 ,
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907 .
If I misunderstood it, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-xicaiCommunity Support
Hi javitxin42 ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
- Syndicate_AdminAdministrator
Hello, I have a problem with a table and I do not know where to follow:
The totals I mark in red do not correspond to the sum of the values in the column. In the right column (DIFFERENCE SIG-Grey Ship), if I export the same table in csv and add them to excel, I get a different total, could someone help me?
Thank you!
- Syndicate_AdminAdministrator
Hello, I put the link to download the file in case you can help me.
Thank you very much in advance.