The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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)
Thank you
Denis
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.
User | Count |
---|---|
14 | |
12 | |
8 | |
6 | |
5 |
User | Count |
---|---|
29 | |
18 | |
13 | |
8 | |
5 |