Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

difference between two rows in a table in Power bi

Hi,

 

I have a table with data as shown below

 

StateSales
AP200
Delhi300
Karnataka400
TN500
Orissia200

 

I want the difference between AP and TN only

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Try a measure like

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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"

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi,

       

      My waterfall chart is as below

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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