Forum Discussion

thanhloan_vee's avatar
thanhloan_vee
New Member
2 years ago

Dynamic Page navigation using string from MDX measure

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

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      thanhloan_vee
      New Member
      2 years ago

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