cancel
Showing results for
Did you mean:
Highlighted
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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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.

2 REPLIES 2
Highlighted
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.

Highlighted
Helper I

This is great, thank you!

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors