SWITCH for multiple expressions

[Cedric]

Hello Everyone,

I have a requirement on a report to display 3 or 4 measures based on 3 different time periods simulatenously. In others words, users do not want to select a measure first and then select a specific time period. They want to select a time period, and the different update accordingly.
I am trying to do it with DAX but am struggling a bit. Is this possible or any advice on how to solve that request ?
Any help is greatly appreciated.

Thank you,

Cédric

[jbressan]

Hi @Cedric

Please review the following post

Problem of the Week #7 (DAX) - Dynamic Report with Calculation Groups

OK, here we go! Problem of the Week #7 is now live! For background on this initiative, check out this post . Note: detailed intro video to this problem has been posted on YouTube, and can be found here Background As Tabular Editor 3 is about to be released therefore, it is a perfect time to get some hands-on practice in Calculation Groups. With this challenge, you will learn how to: Create Time Intelligence Calculation Create Other Metrics Exclude Specific Measures Apply Dynamic …

[EnterpriseDNA]

Hi @Cedric, did the response provided by @Jbressan help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

[EnterpriseDNA]

Hi @Cedric, we’ve noticed that no response has been received from you since the 18th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

[HASSAN_BI]

Hi @Cedric,
Can you prepare a PBIX file so that we can have a concrete view of the problem.
Or at least send a picture of that demonstrates the problem.
Thanks

[EnterpriseDNA]

Hi @Cedric, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!