Forum Discussion

subburaj's avatar
subburaj
Icon for Helper I rankHelper I
7 years ago
Solved

Finding delta for all measures

Hi Friends - Please see below screenshot for yoru reference.  I would like to create a measure called "Delta" whichc is a difference between 2020 - 2019. and it should come on columns (next to 2020) showing delta between 2019 and 2020 for ALL 6 measures not just 1. Kindly help

 

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    subburaj ,

     

    You need to convert the 6 measures to calculate columns and then create a measure using dax below:

    Spoiler
    Diff = 
VAR Percentage_2019 = CALCULATE(MAX('Table'[Percentage]), FILTER(ALLEXCEPT('Table', 'Table'[Measure]), 'Table'[Year] = 2019))
VAR Percentage_2020 = CALCULATE(MAX('Table'[Percentage]), FILTER(ALLEXCEPT('Table', 'Table'[Measure]), 'Table'[Year] = 2020))
RETURN
Percentage_2020 - Percentage_2019

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi subburaj ,

     

    Did you try using Quick Measure subtraction?

     

    Give a shot.

     

    Thanks,

    Tejaswi

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    subburaj ,

     

    You need to convert the 6 measures to calculate columns and then create a measure using dax below:

    Spoiler
    Diff = 
VAR Percentage_2019 = CALCULATE(MAX('Table'[Percentage]), FILTER(ALLEXCEPT('Table', 'Table'[Measure]), 'Table'[Year] = 2019))
VAR Percentage_2020 = CALCULATE(MAX('Table'[Percentage]), FILTER(ALLEXCEPT('Table', 'Table'[Measure]), 'Table'[Year] = 2020))
RETURN
Percentage_2020 - Percentage_2019

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.