Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Appologies for posting again but I cannot find a solid solution.
I have a matrix in Power BI something like the below
Workstream | Employees | Platfrom 1 | Platform 2 | Platform 3 | Platform 4 |
A | 4 | 1 | 5 | 4 | 5 |
B | 20 | 5 | 5 | 5 | 5 |
C | 10 | 4 | 5 | 6 | 4 |
Note that columns Platform 1 - Platform 4 are all calulated measures that contain the count of employees for that specific platform (it's a simple measure with a filter per platform).
My Issue
I have RLS on the data table that filters the data on the company of the user. Based on the company I want to show/hide columns Platform 1 - Platform 4.
So lets say the user works for company x then they should only see Platform 1,
If the User works for company x & y they should see Platfrom 1 & 2 but not 3 & 4.
Can someone let me know if this is possible?
@obriaincian , OLS can do, but it will error.
With userprincipalname() you can make value blank for measures
If(userprincipalname() = "Abc@abc.com", [M1], blank())
or
If(userprincipalname() = "Abc@abc.com", [M1],[M2])
you can check a table
If(userprincipalname() in values(Table[Email]), [M1],[M2])
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |