Subtract values according to condition

[Anonymous]

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 measure.

Store Benchmark = is a value from a table.

Total Benchmark = Store 6 Benchmark (28%) - Store 6 Total (12%) = 16%

I'm blocked with something that seems pretty simple.
Would it help me understand the problem of why I can't subtract it?

Thanks!

Regards!

[Tahreem24]

Have you made proper relationship between those two table?

[Anonymous]

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

[Tahreem24 · Accepted solution]

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]

Thanks @Tahreem24  !

[Tahreem24]

@Anonymous ,

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

Thanks!