So You Think You Know DAX 12-18-2017 02:50 AM - last edited 03-29-2018 20:53 PM

[Daniil]

This is a five-question quiz on DAX.

Can you answer all five questions correctly? 🙂

Enjoy!

Daniil Maslyuk

https://xxlbi.com/

https://twitter.com/DMaslyuk

eyJrIjoiMzc5OWMyMDYtNGE3MS00OWUzLTgzZjEtN2FlZDcyOGQyZTQwIiwidCI6ImQzMmNkYzNmLTY1NTUtNGNhYy1iYjFhLTg2OWZiMTE0MzRlNSJ9

[veejess]

This is brilliant. Having the DAX formulae on the answer page would have been helpful! 

[Rod]

This is probably basic but as a newbie I must ask how do you create buttons that allows you to navigate through pages.

In this case, th answer button.

[prateekraina]

That is achieved by bookmarks. So you basically create an image as a button by linking it to a preset bookmark.

[Daniil]

@veejess, thanks for your feedback! DAX formulas should now be visible in answers 🙂

@Rod, @prateekraina gave the correct answer to your question 🙂

[veejess]

@Daniil, awesome, thanks. I've only started my journey with DAX and your 5 queries has helped me to undersand few things.  

[Rod]

Oh I see, Thanks a lot for your input!

[MFelix]

Hi @Daniil,

Great dashboard !

Just one question that I have already seen in another dashboard but was not abble to get it.

How do you achieve to "save" the answers in order to have the final graph? 

Thank you.

Regards,

[hohlick]

Excellent, Daniil!

The best effect is on the last step!

Kudos!

Maxim

[Daniil]

@hohlick, thank you, Maxim 🙂

@MFelix, are you referring to "How well do you know the Simpsons"? I think they used a custom visual to achieve the effect of "saving" answers. In my report, I am not using any custom visuals -- only the built-in features of Power BI Desktop. I used the latest enhancements to the bookmarking feature, which allow you to modify only selected visuals and not the entire page. I might write a blog post on it to explain better 🙂