cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## 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 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!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II

## Re: Subtract values according to condition

Measure =CALCULATE(sum(Column1) - Sum(column2), storeId=6)

Please give Kudos to this effort and mark it as a solution if it helps you.
5 REPLIES 5
Super User II

## Re: Subtract values according to condition

Have you made proper relationship between those two table?
Regular Visitor

## Re: Subtract values according to condition

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

Super User II

## Re: Subtract values according to condition

Measure =CALCULATE(sum(Column1) - Sum(column2), storeId=6)

Please give Kudos to this effort and mark it as a solution if it helps you.
Super User II

## Re: Subtract values according to condition

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

Thanks!

Regular Visitor

## Re: Subtract values according to condition

Thanks @Tahreem24  !

Announcements