Forum Discussion

newpbiuser01's avatar
newpbiuser01
Helper V
3 years ago

Row Level Filtering in DAX

Hello,   I am looking to implement row level filtering in DAX using the userprincipalname() function. I have two data tables, one with the salary data, and another with the employee access details....
Need Help
parry2k's avatar
parry2k
Super User
3 years ago

newpbiuser01 do you want to completely hide the row or want to show the value "Hidden" in place of salary and level?

 

What is the ask here?

  • newpbiuser01's avatar
    newpbiuser01
    Helper V
    3 years ago

    Hi parry2k ,

    I want to show the value "Hidden" instead of the actual value for the Salary and Level columns if the user does not have access the data for that department. This way the user can see some other columns (that I haven't shown in this example) but just can't see the senstive data.