Forum Discussion

Reawaken's avatar
Reawaken
Regular Visitor
3 years ago
Solved

Add up values in one column based on whether a value in another column is of a specific value

Hi there,   I am trying to add up values in a column based on whether a value in another column has a value of 4 or 5.   What I'd like to be able to do, from the information in the pictur a...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Write this measure and drag it to a card visual

    Measure = calculate(sum(Data[Balance]),data[new crate]=4||data[new crate]=5)

    Hope this helps.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Reawaken , In case you need a new column

 

New column = if( Equifax[New Crate] in {4,5} , [Balance], blank())

 

Reawaken's avatar
Reawaken
Regular Visitor
3 years ago

Hi Amit,

 

You're right that my table is called Equifax, with dimenions Balance, New Crate, etc., but I dont think your expression is working cause I don't see the drop down to select "Equifax[New Crate]" after the "IF" statement.  Help!  I'm a newbie at this haha.

 

Thanks!

 

Paul