cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to calculate the difference between two numbers to create new measure

I'm trying to calculate a value which I believe should be a measure but am not sure how to do it.  I have a set of data points for a list of brands and I want to create a new value which calcuates the difference between two of the values.

 

The data is structured as follows

Brand 1  - Aware  - 60%

Brand 1 - Familiar - 20%

Brand 1 - Would recommend - 15%

Brand 2 - Aware - 45%

Brand 2 - Familiar - 13%

Brand 2 - Would recommend - 3%

 

Familiar is a subset of those Aware and I would like to create a a measure that is 'Aware but not Familiar' - e.g. For Brand 1 it would be 60%-40% = 20%.  Is that possible?

 

Thanks in advance for any advice!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Hi @SimonJacobs. It sounds like this is already in a table with the structure you provided. I'll call the columns Brand, Impression, and Percent. With that, you could start with a simple measure:

 

Percent Sum = SUM(TableName[Percent])

 

That might not be useful on its own, but you can use it in two more measures that specify how you want to calculate it:

 

Percent Aware = CALCULATE([Percent Sum], TableName[Impression]="Aware")
Percent Familiar = CALCULATE([Percent Sum], TableName[Impression]="Familiar")

 

Combine those to get your end result:

 

Aware but not Familiar = [Percent Aware] - [Percent Familiar]

 

You could do all of that in one step, but those building blocks will help with your readability and you can reuse them for other measures as well.

View solution in original post

2 REPLIES 2
Highlighted
Solution Sage
Solution Sage

Hi @SimonJacobs. It sounds like this is already in a table with the structure you provided. I'll call the columns Brand, Impression, and Percent. With that, you could start with a simple measure:

 

Percent Sum = SUM(TableName[Percent])

 

That might not be useful on its own, but you can use it in two more measures that specify how you want to calculate it:

 

Percent Aware = CALCULATE([Percent Sum], TableName[Impression]="Aware")
Percent Familiar = CALCULATE([Percent Sum], TableName[Impression]="Familiar")

 

Combine those to get your end result:

 

Aware but not Familiar = [Percent Aware] - [Percent Familiar]

 

You could do all of that in one step, but those building blocks will help with your readability and you can reuse them for other measures as well.

View solution in original post

Highlighted

This is great, thank you!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors