Creating a filter based on USERPRINCIPALNAME

[Duygu_Gnd]

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.

Domestic/Interstate = IF(Users[user State]=LOOKUPVALUE(Users[user State],Users[email],USERPRINCIPALNAME()),"Domestic","Interstate")

[v-luwang-msft]

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

[v-luwang-msft]

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

[amitchandak]

@Duygu_Gnd , You can create a  measure as only one value would be there for use login(userprincipalname )

[Duygu_Gnd]

Hi @amitchandak , sorry, not sure how this will solve my problem above?