topic Re: Dynamic Page navigation using string from MDX measure in Developer

Dynamic Page navigation using string from MDX measure

thanhloan_vee — Mon, 29 Jul 2024 11:50:10 GMT

Hi all,

Currently my Power BI report is connected to OLAP database.
What I want is to create a navigate button, in which the destination will be dynamic based on the user access rights (I have already had the file maintained the returned string for each user)
For example, I have user A and user B.
The measure will be: if(user = User A, 'Budget A', 'Budget B') and it'll returns the string = page name, so it can navigate to that page.

With DAX query, it works well. But with MDX, I can't add the measure to the 'fx' (conditional formatting, i guess?)

Is there any ideas to implement it or why I can't add my measures ??
Thank you in advance

Re: Dynamic Page navigation using string from MDX measure

Anonymous — Tue, 30 Jul 2024 05:55:24 GMT

Hi @thanhloan_vee ,

As far as I know, Power BI support you to use dax code to creates measures.

Refering to this offical blog, I think Power BI doesn't support us to create measures by MDX.

For reference: Building Measures in MDX | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Dynamic Page navigation using string from MDX measure

thanhloan_vee — Tue, 30 Jul 2024 06:28:12 GMT

Hi @Anonymous ,

Thanks for your reply.

I know that from the Power BI tool itself only allows to use Dax code.
But in my situation, I connect to SQL Server Analysis Service (which is OLAP, as I mentioned above) and Power BI is now a tool to visualization, not build the report.
It's just kinda weird that I can't add the measure to the 'fx' function. No detail error message -.-