Forum Discussion

SimonJacobs's avatar
SimonJacobs
Icon for Helper I rankHelper I
10 years ago
Solved

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!

Need Help
  • KGrice's avatar
    KGrice
    10 years ago

    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

  • KGrice's avatar
    KGrice
    Icon for Memorable Member rankMemorable Member
    10 years ago

    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.