Forum Discussion

Giada90's avatar
Giada90
Helper 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
Super 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
Helper 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