Forum Discussion

justine0812's avatar
justine0812
Frequent Visitor
3 years ago

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.

 

 

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

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    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").