• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Identify level of attribute in Matrix


New Member
I have case which seems to be simple but I can't crack it: imagine there is standard fact table + dimensional table with attributes Att1, Att2,... Att6. I need to create a measure which returns values only for Att2 and Att5. For all other attributes it has to be blank. Unfortunately, I can't create a hierarchy and solve this problem by using switch() in combination with isinscope() because attributes in the Matrix (I mean Power BI visual) may have random order (via personalized visuals). So one user can organize the matrix as Att2, Att4, Att5... and other user as Att5, Att4, Att3, Att2... and both scenarios business-wise makes sense.
Thx for any hint,
Last edited:


Excel Ninja
Staff member

Can you please attached a sample file with some data before and after transformation demonstrating what you require.