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

[Mbryanton]

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 measure to add the values if the same origin column does not equal those first 4 locations. 

[PijushRoy]

Hi @Mbryanton 

I am sharing the idea of the DAX measure, please update 

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

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

If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Mbryanton]

Hi there! The second measure works! but I get an error when trying to apply the first one ( Measure - Not Included) that says " Couldn't load the data for this visual - A table of multiple values was supplied where a single value was expected?

[Mbryanton]

Hi there! The second measure works! but I get an error when trying to apply the first one ( Measure - Not Included) that says " Couldn't load the data for this visual - A table of multiple values was supplied where a single value was expected?

[PijushRoy · Accepted solution]

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]

YES! Thank you so much for your help 🙂

[PijushRoy]

You are welcome @Mbryanton