Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating a filter based on USERPRINCIPALNAME

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 sta...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi Anonymous ，

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