cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Tutuka28 Regular Visitor
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%

 

1.JPG

 

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

View solution in original post

5 REPLIES 5
Super User II
Super User II

Re: Subtract values according to condition

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

Re: Subtract values according to condition

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

Super User II
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.

View solution in original post

Super User II
Super User II

Re: Subtract values according to condition

@Tutuka28 ,

 

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

Thanks!

Tutuka28 Regular Visitor
Regular Visitor

Re: Subtract values according to condition

Thanks @Tahreem24  !

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors