Dynamic masking Customer Name depending of security table. In DAX. No calculated column please
Hi, I will want to hide customer names dynamically based on user. I don't want to go through a calculated column! The radacad solution does not suit me because it goes through another table. I don't want to duplicate my data.
The email addresses of my users are in a "Security" table.
I would like to be able in an array to have something like: "IF (The current user is in the table" Security THEN show "Secure" ELSE Show the current name of the client)
Well, if you want to have a dimension that will be dynamically adjusting itself to the security context... then you don't have a choice: you have to store the obfuscated names somewhere. There's no way around this, I'm afraid.