SWITCH and IF statements

[justine0812]

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!

[lbendlin]

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