Column figures in Matrix

[Genoa]

Hi,

How can I put the breakdown of the sum of the columns in matrix table? It displays the same sum value (image attached). As you can see under the customer name are different product codes, the values of the sub columns under the "Sum of Budget" is the same as the aggregated "sum value" instead a breakdown value.

Any help is much appreciated.

Kind regards,

Marvin

[Ashish_Mathur]

Hi,

There could be 1 of the following 2 problems:

1. You have written a calculated column formula instead of a measure

2. The relationships are not proper.

[Genoa · Accepted solution]

Hi @Ashish_Mathur 

Thanks for the answer, yeah I think no. 2. Probably not a good solution but I did a merge and pulled the column I need, and it seems to work.

[Ashish_Mathur]

You are welcome.  If my previous reply helped, please mark that as Answer.

[speedramps]

This is a very common question.

Please see Youtube for various tutorials about using SUMX to fix matrix totals.

there are also dozens of abswer to this question in this forum history

https://www.youtube.com/watch?v=Rii_6qkLNh8

https://www.youtube.com/watch?v=eoT-jPzV3Wk

[Genoa]

Thanks for the info @speedramps