Forum Discussion
Solved
Calculate subtotal using dax
I would like to calculate a subtotal using dax (not using the subtotal feature of matrix visual) Sample data: Client Shop Sales A 1 100 A 2 200 B 3 400 B 4 500 ...
Credo Please try this as a "New Measure"
Test107 = CALCULATE(SUM(Test107Measure[Sales]),FILTER(ALL(Test107Measure),Test107Measure[Client]=SELECTEDVALUE(Test107Measure[Client])))
Credo Please try this as a "New Measure"
Test107 = CALCULATE(SUM(Test107Measure[Sales]),FILTER(ALL(Test107Measure),Test107Measure[Client]=SELECTEDVALUE(Test107Measure[Client])))
Thanks a lot