Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
For quite some time I have problems with my SWITCH() function in Power BI Desktop.
If you look at the attached picture you can see that I created a SWITCH() function called "metric selection". With this metric selection, it is possible for the end-user to choose a metric by choice.
This SWITCH() function is created quite some time ago but now when I open this "metric selection" I only see errors, saying the syntax is incorrect. When I open this exact same "metric selection" on my colleague his PC or another PC I don't get this syntax error.
Does anyone know why only I see this error?
Hopefully, someone can help me out here.
Sorry, looking closer it looks like it does not recognize your creative_impressions measure or any other measure for that matter. I have seen this sometimes and you can fix it by simply going into your DAX and removing creative_impressions and then adding it back in. Usually, that fixes that instance and all other instances of where it is not recognizing your measure. Don't ask me why but I have had to do this several times although it generally happens while I am editing a measure in DAX it sort of loses it's mind.
Interesting @Greg_Deckler I never came across this until this post.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Can you post the DAX for your creative_impressions measure? That seems to be what is causing the error. It is possible that you are running a newer desktop than your coworker perhaps and maybe something changed?
As you can see I get no errors in my creative_impressions measure.
I and my coworkers are using the February 2019 or March 2019 version but I don't think the problem lies there because until yesterday I also was using the February 2019 version.
I will try your solution regarding removing the measures and adding it back. Hopefully, this helps! Otherwise, I don't know what to do anymore.
@Anonymous this is strange. Do you see those measures used in switch statement on your machine?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |