Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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

 

 

 

ClassTypeTotal
AHS500
AHS500
ZHS500
ZHS500
ZHS500
ZHS500
CTM760
LTM760
...
...
...
...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    Anonymous So tweak your measure like below:

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

6 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    4 years ago

    Hey Anonymous ,

     

    you can just create a matrix and put the Type in the rows and the total in the values. Then it will sum by Type.

    Otherwise you could create measures:

    Sum HS =
CALCULATE(
    SUM( myTable[Total] ),
    myTable[Type] = "HS"
)

     

    and for TM:

    Sum TM =
CALCULATE(
    SUM( myTable[Total] ),
    myTable[Type] = "TM"
)

     

    The measures set the filter of the type to HS or TM and for that reason you will always get the sum for the corresponding type.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 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
    Super User
    4 years ago

    Anonymous Create a measure like below:

    Measure = CALCULATE(SUM('Table'[Total]),ALLEXCEPT('Table','Table'[Type]))
     
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 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
        Super User
        4 years ago

        Anonymous So tweak your measure like below:

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

    Hi Anonymous ,

     

    Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

     

    Hope it helps,


    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.