Multiple Buttons Based on One Dax Measure

StanHost12 — Wed, 06 Nov 2024 16:42:58 GMT

Hello!

Background:

I am relatively new to Power BI and Dax and have had issues understanding the way Dax works sometimes. The visualization I am making has buttons that lead to other pages. I have functional page navigation buttons that are based on what is selected in the filter/slicer above it (using a SWITCH statement and/or an IF statement). I want it to be better/more modular and efficient by making all of the buttons be based on the same page navigation measure rather than one measure for each button.

Example:

When performance measure 4-1 is selected I want Button 4 to function and be able bring me to a new page if I were to click on it, and if I were to click on Button 3 it would not do anything (keep me on this page).

If performance measure 3-1 is selected I want Button 3 to being me to a new page it leads to if I click on it while Button 4 doesn't function (keeps me on this page).

I can do this with individual measures.

With a singe measure used for both I can only right now, through a SWITCH function, make it so if neither (3-1 or 4-1) are selected neither button takes you anywhere. If 3-1 is selected both buttons take you to the page intended for just Button 3. If 4-1 is selected both buttons take you to the page intended for Button 4.

Does anyone have a potential solution for this? Any help would be greatly appreciated, thanks!

Re: Multiple Buttons Based on One Dax Measure

lbendlin — Wed, 06 Nov 2024 20:33:11 GMT

I have functional page navigation buttons that are based on what is selected in the filter/slicer above it (using a SWITCH statement and/or an IF statement).

Your job as a developer is to put as few clicks as possIble between your users and the insights. "Page navigation" is not a productive element in that job. Rethink your approach, eliminate the buttons, use the standard navigation features the way they are intended to be used.

topic Re: Multiple Buttons Based on One Dax Measure in DAX Commands and Tips

Multiple Buttons Based on One Dax Measure

Re: Multiple Buttons Based on One Dax Measure