Tableau to Power Bi Migration

Hi Anonymous ,

Thank you for reaching out to Microsoft fabric community forum.I also want to thanks bhanu_gautam  for valuable input the suggested approach involving dynamic measures for calculating Booking Amount, implementing Top N filtering, and generating rankings is correct.

However, I would like to have a clarification regarding the use of SELECTEDVALUE() within calculated columns:

To implement dynamic switching in the matrix visual based on slicer selection (e.g., Customer Type), consider the following approach:

• Create a unified table using the UNION function that consolidates all relevant customer types along with their IDs and Names.
• Use measures (rather than calculated columns) to implement dynamic logic for both display and filtering including the Top N logic.

This method ensures the matrix visual responds correctly to slicer selections and maintains optimal performance and flexibility.

Hope this helps. Please reach out for further assistance.

If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.

Thank you.