Forum Discussion

Gabiiiii's avatar
Gabiiiii
Frequent Visitor
4 years ago

RLS cannot be applied to DAX Calculated Table

In order to meet certain format, I have to create an independent DAX table to display this chart in the report, and this format is not able to be directly generated from the raw table: 

However, the RLS need to be controlled to BU level, but the BU field is not able to be showed in this DAX table (everything is calculated in DAX formula in advance), so that the chart I made by this DAX table would igore role level security.

 

Is there any DAX formula that can involve BU filtering when generating this calculated table, or any other workaround?

 

Thank you so much!