difference between two consecutive rows

[Anu]

Hello,

I am trying to create a column (difference) in which  votes achieved are subtracted from max votes achieved. I am able to do so for whole table, but if I apply filter to consituency name = any option, it don't change the value. I want the difference value should now consider max value of filtered consituency data. 

Please find relevant images for same. Help me achieve it, please!

[v-ljerr-msft · Accepted solution]

Hi @Anu,

If I understand you correctly, you should be able to use the formula below to create a measure(not column) to calculate difference in your scenario. 

measure =
CALCULATE ( MAX ( 'table1'[votes achieved] ), ALLSELECTED ( 'table1' ) )
    - MAX ( 'table1'[votes achieved] )

Note: You'll need to replace 'table1' with your real table name.

Regards

[Anu]

Thanks @v-ljerr-msft 

I am begineer on Power BI. It was a great help. Appreciate it.

Regards

Anu