Forum Discussion
Power BI RLS Roll Based Not affecting DAX table
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
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
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.