Forum Discussion

srkase's avatar
srkase
Helper IV
7 years ago

DAX COMMAND

I have one excel sheet with the following column names..

 

shortname with values north,east,west,south ---- [which contains list of all our sales areas]

category with values motors, pumps,panels ----- [ list of items sold]

 

I have created a RLS using dax with  [Shortname] in {"North","west"} and applied it for a user in BI dashboard.

Now for the same user i need to give access only to [Category] {"motors"}.

 

Kindly post me the dax command for this .

 

I am a beginner in BI dashboard..

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Mate, you have to have a mapping table from the username (USERNAME() or PRINCIPALUSERNAME()) to the categories you want the user to be able to view. Then and only then can you create what you want. Please try to google RLS in DAX if nobody gives you a ready-made solution. There are many blogs out there treating this topic.

     

    Best

    Darek