Power BI RLS Roll Based Not affecting DAX table

[jfletty]

I am starting to use RLS with my PowerBI model and all is working well apart from an issue where a table created from a DAX is getting the details from another table ignoring the row level security.

I have a 'Sales' table with 10,000 rows it in and is filtered on a 'SiteID' which when filtered down, limits the displayed to 3,000 rows (this is correct). But when i create a DAX table based off this 'Sales' table, it shows data from all the rows not just what is limited by RLS.

First image of the Security Table: 

Second is of the Dax Query and table which needs to be filtered: 

Let me know where in my DAX query I am going wrong.

[Anonymous · Accepted solution]

HI @jfletty,

Current power b not support to create dynamic calculated column/table based on filter, please take a look at following link to know more about this:

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

In my opinion, I'd like to suggest you create a normal calculated table and use RLS filter to control which records will display.

Steps:

create table, build relationship to RLS table, modify 'cross filter direction' to both and turn on 'apply security filter in both direction' option.

Regard,

Xiaoxin Sheng

[Anonymous]

Do you know this is still the case? I'm having what appears to be the same problem and I can't find a write-up online about why this happening or how to work around it.