Forum Discussion

Mbryanton's avatar
Mbryanton
Regular Visitor
2 years ago
Solved

Help with a writing a DAX function based on conditions of another column

I am still very new to DAX, but I have a table where I need to create a DAX measure to add up the values from the Values column if the Origin Column equals 4 specific locations. And then another meas...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Try this

    Measure(not included) =
CALCULATE (
    SUM ( 'Table'[Value] ),
    'Table'[Origin] NOT(IN { Origin1, Origin2, Origin3, Origin4 })
)

     

    Mark this answer as solution, if works for you

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Try this

Measure(not included) =
CALCULATE (
    SUM ( 'Table'[Value] ),
    'Table'[Origin] NOT(IN { Origin1, Origin2, Origin3, Origin4 })
)

 

Mark this answer as solution, if works for you

Mbryanton's avatar
Mbryanton
Regular Visitor
2 years ago

YES! Thank you so much for your help 🙂