Dynamic Page navigation using string from MDX measure

[thanhloan_vee]

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

[Anonymous]

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.

[thanhloan_vee]

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 -.-