Forum Discussion
% Column to Total using Calculation rather than Average
Afternoon,
I have a table with Rows and Columns i need to try and have the total as a the same calucation the rows do.
So for example image below the total should be 57% not 42% at the moment i have summarise set to "average"
Hi, sovereignauto ;
Based on my test, maybe it is better to use sum() to divide, and its total will be correct. I made a simple example and measured as follows：
sum = DIVIDE(SUM('Table'[value2]),SUM([value1]))The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hello sovereignauto
You can use sumx function to solve this.
I can write you the solution directly If you could provide sample .pbix file.
Regards
Kumail Raza
HI Kumail, i can use sumx in DAX but how would i get thsi to display as the total or do you "cover" the old total with a card or similar so it looks correct?
This is one of the blogs that you can refer
https://blog.enterprisedna.co/getting-totals-correct-when-using-advanced-logic/
I can also help you with the solution once .pbix file is available.
Regards
Kumail Raza
Hi, sovereignauto ;
Based on my test, maybe it is better to use sum() to divide, and its total will be correct. I made a simple example and measured as follows：
sum = DIVIDE(SUM('Table'[value2]),SUM([value1]))The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
