Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter report on Userprinciplename()

Is it possible to filter a report on userprinciplename()? I'm not talking about row level security, this I can do. I'd like to be able to filter a report page on userprinciplename() matching a data table value so that measures that include the ALL function will include all data but measures and fields without the ALL functionwill be filtered just to the userprinciplename()? i.e. I want to use RANK and ALL to rank this user against other users but I don't want this user to be able to see other users ranks. 

Need Help

1 Reply

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi , Anonymous 

    According to your description, you want to use Userprinciplename() to filter a report and you do not want to use rls?

    First , this dax code can not be used in the calculated column and the table. It can only be used in the measures.

     

     The measure can only return the value you want to calculate . If you want to filter the report , i think you actually to combine  the Userprinciplename() with the "RLS"  to filter the data for each end user. Only the RLS can filter the data for the different user .

     

    For more information, you can refer to :
    Dynamic Row Level Security with Profiles and Users in Power BI : Many-to-Many Relationship - RADACAD

    DAX USERPRINCIPALNAME - Use in RLS - Power BI Docs

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly