Forum Discussion

spagad6263's avatar
spagad6263
Post Patron
2 years ago
Solved

How to filter table by USERPRINCIPALNAME()

Hi, I would like to filter data by USERPRINCIPALNAME() via RLS.    For in stance, in below table, when USERPRINCIPALNAME = '[email protected]', it should show first 2 rows, which contains '[email protected]...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    spagad6263 I don't use this new look, I don't like it at all. Switch to the DAX editor and past the code there.

spagad6263's avatar
spagad6263
Post Patron
2 years ago

Thanks for the reply. I've created below measure. Can you advise how I could link this to the role?

meas_Filter =
VAR UPN = USERPRINCIPALNAME ()
RETURN
CALCULATE (
   COUNTROWS (fact_Contact),
   CONTAINSSTRING (fact_Contact[MappingEmailAddress], UPN)
)