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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
justine0812
Frequent Visitor

SWITCH and IF statements

Hi,

 

I am trying to create a DAX measure that follows a slicer whether the selected currency is EUR or GBP. I have the following DAX measure but it doesn't seem to work. I'm just a bit confused how SWITCH works, because as per my logic it should work, but it doesn't seem to.

 

justine0812_0-1680097493669.png

 

I have created here a table for the currency slicer (GBP or EUR) and created a measure for "Selected Currency" that I have to use in doing the SWITCH function. The idea is "IF GBP is selected, use the following filters and then sum up a column in the table. 

 

But it doesn't seem to work. Would anyone be able to help me?

 

Thanks!

 

1 REPLY 1
lbendlin
Super User
Super User

Use DAXFormatter.com to make sense of your rather complex code and then refactor it .  Note that you can have nested SWITCH statements.  Also note that SWITCH only improves readability. It is technically the same as nested IFs  (sometimes also called "syntax sugar").

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.