Calculated Table RLS issue

[_chris_]

Hi,

I have a table which containes bookings for all cost center (..KstAuswertungMitPlanung).

I have another table which holds all the cost center (Kst) a particular user is allowed to see (dimKstRechte, right visual) which is filtered by the user by RLS.

Now I want to create a calculated table which is filtered by the values of the "rights" table (see table definition in screenshot)

However, the filter does not work as it also shows data for cost center (Kst) 5310 and 5320

However, if I am using the DAX

Tabelle = FILTER(FASTEC_backofficeKstAuswertungMitPlanung, FASTEC_backofficeKstAuswertungMitPlanung[Kst] IN {"5200"})

it works and I am only seeing the values for 5200.

Where is my mistake?

Thx, Christian

[aduguid]

You can either relate the calculated table to the table the row level security (dimKstRechte) in your model view or include (dimKstRechte) in the summary calculated table and update the roles to include both your summary table and (dimKstRechte).