Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I have following user table and I have applied Row Level Security based on Organisational Hierarchy. I would like to create a slicer based on logged in user as if logged in person's state is same as user's state then "Domestic" else "International". However, I can't use USERPRINCIPALNAME in calculated columns/tables. so any idea if that's doable? thanks
PATHCONTAINS(Users[Path_Func],LOOKUPVALUE(Users[user ID],Users[email],USERPRINCIPALNAME()))
Formula not working beacuse we can't use USERPRINCIPALNAME in calculated columns/tables.
Hi @Duygu_Gnd ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
Hi @Duygu_Gnd ,
As we can see from the error message, it isn't supported. What's your purpose? Maybe there are other approaches. For example, we can use a measure like this, then we can filter out these 0s in the Filters.
Measure =
CALCULATE (
IF (
MIN ( Users[email])
=USERPRINCIPALNAME (),
1,
0
)
)
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
@Duygu_Gnd , You can create a measure as only one value would be there for use login(userprincipalname )
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |