Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Mbryanton
Regular Visitor

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

1 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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





View solution in original post

6 REPLIES 6
PijushRoy
Super User
Super User

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

 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





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?

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





YES! Thank you so much for your help 🙂

You are welcome @Mbryanton 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.