% Column to Total using Calculation rather than Average

[sovereignauto]

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" 

[v-yalanwu-msft · Accepted solution]

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.

[Kumail]

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

[sovereignauto]

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? 

[Kumail]

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