Dynamically show dimension column based on user

[Goofr]

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

[PurpleGate]

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 · Accepted solution]

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