Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a simple dimension table wich is related to my fact table.
This dimension table has 3 columns: 'id' (key), 'file' and 'file masked'.
Now when the user which is logged in has a special permission (based on Excel data) he may see the values in the 'file' column.
If he doesn't have this permission he should see the values in the 'file masked' column.
How can I obtain this functionallity using DAX.
Thanks in advance
Frank
Solved! Go to Solution.
Hi,
Thanks for your reply.
But I don't want to remove rows.
The data that needs to be shown is in the same record, however the displayed column has to be dynamic.
I ended up using the SELECTEDVALUE function.
In combination with some other filters I finally have a solution.
Thanks anyway.
Frank
Is it separate rows you want to remove based on the column [File Masked]?
In the Modeling tab, there is an option to manage roles there.
I created a column with 1s and 0s to show which rows I wanted the user to see.
Then I can test the view here:
Then to apply it, I go to My workspace > Security > and then type what group of people can see what view.
Hi,
Thanks for your reply.
But I don't want to remove rows.
The data that needs to be shown is in the same record, however the displayed column has to be dynamic.
I ended up using the SELECTEDVALUE function.
In combination with some other filters I finally have a solution.
Thanks anyway.
Frank
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |