Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sum by two groups

Hi everyone , I need help with this issue i have a table visual: User level Salery A 1 34 B 2 32 B 2 37 C 1 26 C 3 28 C 1 29 D 3 33 E 1 30  if i re...
Need Help
danextian's avatar
danextian
Super User
4 years ago

Hi Anonymous ,

Try this measure below which is similar to COUNTIF in Excel:

MyMeasure =
CALCULATE ( SUM ( Table[Salery] ), ALLEXCEPT ( Table, Table[User] ) )
//will return the sum of Salery for each User

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your reply but it doesnt work 😞 , i didnt get the result

  • danextian's avatar
    danextian
    Super User
    4 years ago

    What would your formula be if you did it in Excel?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi again , I dont have any formula :), i just dont get right value.