Forum Discussion
Controlling subtotals formula in a Matrix
Hi all,
I'm looking to solve the following issue:
- I have defined three measures that are connected, meaning that measure 1 is used to assess measure 2 and measure 2 is used to assess measure 3
- After successfully achieved measure 3, I'm facing the issue that in Matric visual, the subtotal amount does not add up to the result of each individual row. I have put an example below.
Any idea on how to turn subtotals to actually add individual line instead of using the set formula in measures?
Thank you
J
10 Replies
v-caliao-msftMicrosoft Employee
Hi costadom,
I have tested it on my local environment, everything works fine.
Measure 2 = Sheet9[Measure]+11
Measure 3 = Sheet9[Measure 2]+13In your scenario, please provide us some sample data and your measrure forumla, so that we can try to reproduce this issue and make further analysis.
Regards,
Charlie Liao
- MattAllington
Community Champion
Try
=sumx(values(table[size]),[measure 3])
The issue is the way filter context works.
Read my article here http://exceleratorbi.com.au/sum-vs-sumx-in-dax/
Hi Matt,
Sorry for late reply and thank you very much for your help!
Your formula allmost worked !
See below another more detailled example of my issue.
Let me know if you have any idea on how to fix it since your formula is working for 2 rows out of 5
Thank you in advance for your help!
Jerome
- MattAllington
Can you also post an image of the visual with the formula I provided in place so I can see what that is returning
