Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
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?
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
YES! Thank you so much for your help 🙂