difference between two rows in a table in Power bi

[Anonymous]

Hi,

I have a table with data as shown below

State	Sales
AP	200
Delhi	300
Karnataka	400
TN	500
Orissia	200

I want the difference between AP and TN only

[amitchandak]

@Anonymous , Try a measure like

Calculate(Sum(Table[sales]), Table[State] ="AP") - Calculate(Sum(Table[sales]), Table[State] ="TN")

[Anonymous]

Hi,

My waterfall chart is as below

I want the last two bars to come down and not up

[Anonymous]

Hi @Anonymous ，

Are ”the last two bars“ you mentioned the ones circled in red in the picture below? According to the data shown in your screenshot these two values are both negative and are indeed decreased...

In order to provide you a suitable solution, could you please share some sample data and Fields settings that you refer to in your waterfall visual as shown below?Also please provide your expected result with more details(example, screenshot etc.). It is better if you can provide a simplifiedpbix file. Thank you.

Best Regards

[Anonymous]

It is working, but we want to display this value in watefall chart, but in waterfall chart, we are not able to put this column "Difference"