Hello,
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,
Vitro
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,
Vitro
Last edited:
