Forum Discussion

Giada90's avatar
Giada90
Icon for Helper IV rankHelper IV
4 years ago
Solved

problem with a calculation

Hi,  I have a table with two fields like this: type value A 10 B 3   I need to make a measure that subtracts value A from value B Which dax formula can I use? Thanks
Need Help
  • ddpl's avatar
    ddpl
    4 years ago

    Giada90 try this

     

    Measure 2 = var _A = CALCULATE(SUM('Yourtable'[value]),'Yourtable'[type] = "A")

    var _B = CALCULATE(SUM('Yourtable'[value]),'Yourtable'[type] = "B")

    return

     (_A - _B)
  • Giada90's avatar
    Giada90
    4 years ago

    thanks!

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
4 years ago

Hi Giada90 ,

 

You can create a DAX expression to get this done.

But before that you will need to add an Index column to your data.

I am not sure on how big is your data?

You haven't mentioned if you need to do this subtraction at you type column level or something else? This information is needed to understand whether you have multiple rows for same type.

Please provide atleast 5-10 rows in your sample data, to cover all the scenarios.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 

Giada90's avatar
Giada90
Icon for Helper IV rankHelper IV
4 years ago

Pragati11 , Hi, the real model is about 1700 rows and I need to do this substraction at my type column level, thanks

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

    Hi Giada90 ,

     

    So can you please provide more number of rows in your sample data please rather than just 2 rows?

     

    • Giada90's avatar
      Giada90
      Icon for Helper IV rankHelper IV
      4 years ago

       

      Pragati11, I need to have the sum of all the values that match with A and substract all the values that match with B, I attached more simple data, thanks 

      typevalue
      A10
      B3
      A5
      B4
      A7
      B3
      A9
      B2
      • ddpl's avatar
        ddpl
        Icon for Solution Sage rankSolution Sage
        4 years ago

        Giada90 try this

         

        Measure 2 = var _A = CALCULATE(SUM('Yourtable'[value]),'Yourtable'[type] = "A")

        var _B = CALCULATE(SUM('Yourtable'[value]),'Yourtable'[type] = "B")

        return

         (_A - _B)