Forum Discussion

Goofr's avatar
Goofr
Advocate IV
4 years ago
Solved

Dynamically show dimension column based on user

Hi,

 

I have a  simple dimension table wich is related to my fact table.

This dimension table has 3 columns: 'id' (key), 'file' and 'file masked'.

Now when the user which is logged in has a special permission (based on Excel data) he may see the values in the 'file' column.

If he doesn't have this permission he should see the values in the 'file masked' column.

How can I obtain this functionallity using DAX.

Thanks in advance

Frank

DAX
Dynamic
  • Goofr's avatar
    Goofr
    4 years ago

    Hi,

    Thanks for your reply.

    But I don't want to remove rows.

    The data that needs to be shown is in the same record, however the displayed column has to be dynamic.
    I ended up using the SELECTEDVALUE function.
    In combination with some other filters I finally have a solution.

    Thanks anyway.

    Frank

2 Replies

  • PurpleGate's avatar
    PurpleGate
    Resolver III
    4 years ago

    Is it separate rows you want to remove based on the column [File Masked]?

     

     

    In the Modeling tab, there is an option to manage roles there.  

     

     

    I created a column with 1s and 0s to show which rows I wanted the user to see.

     

     

    Then I can test the view here:

     

     

    Then to apply it, I go to My workspace > Security > and then type what group of people can see what view.

     

     

     

     

     

     

    • Goofr's avatar
      Goofr
      Advocate IV
      4 years ago

      Hi,

      Thanks for your reply.

      But I don't want to remove rows.

      The data that needs to be shown is in the same record, however the displayed column has to be dynamic.
      I ended up using the SELECTEDVALUE function.
      In combination with some other filters I finally have a solution.

      Thanks anyway.

      Frank