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/