Finding delta for all measures

[subburaj]

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

[v-yuta-msft · Accepted solution]

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

[Anonymous]

Hi @subburaj ,

Did you try using Quick Measure subtraction?

Give a shot.

Thanks,

Tejaswi