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 measur...
MattAllington
Community Champion
Community ChampionTry
=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
See enclosed.
Thanks Matt!
Jerome
