Forum Discussion
Sum by two groups
Hi experts, Would you please help me sum the total by both type and class End result should be HS--> 1000 TM --> 1520 Class Type Total A HS 500 A HS 500 Z H...
Anonymous So tweak your measure like below:
Measure = CALCULATE(SUM('Table'[Total]),ALLEXCEPT('Table','Table'[Class]))
This won't work as it will return 3000 for HS as it is not considering the Class in the equation.
HS should be 1000
Anonymous So tweak your measure like below:
Measure = CALCULATE(SUM('Table'[Total]),ALLEXCEPT('Table','Table'[Class]))