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 speci...
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

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