Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
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").
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |