Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Subtract values according to condition

Hi all ! How are you?   I have the following problem: I need to create a Measure that can subtract the value of a Measure and the value of the Benchmark table. For example Store Total = is measu...
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago
    Measure =CALCULATE(sum(Column1) - Sum(column2), storeId=6)

    Please give Kudos to this effort and mark it as a solution if it helps you.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi Tahreem24 , Yes, both tables are related through the Id_Store.

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago
Measure =CALCULATE(sum(Column1) - Sum(column2), storeId=6)

Please give Kudos to this effort and mark it as a solution if it helps you.
  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ,

     

    Please give KUDOS and accept this as a solution if it helps you so other member can take help from it.

    Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Tahreem24  !