Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    Anonymous So tweak your measure like below:

    Measure = CALCULATE(SUM('Table'[Total]),ALLEXCEPT('Table','Table'[Class]))
     
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
5 years ago

Anonymous Create a measure like below:

Measure = CALCULATE(SUM('Table'[Total]),ALLEXCEPT('Table','Table'[Type]))
 
 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    5 years ago

    Anonymous So tweak your measure like below:

    Measure = CALCULATE(SUM('Table'[Total]),ALLEXCEPT('Table','Table'[Class]))