RLS cannot be applied to DAX Calculated Table

[Gabiiiii]

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!

[v-luwang-msft]

Hi @Gabiiiii ,

Pls refer the following article ,and check if it is helpful.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/DAX-For-RLS/m-p/2367568 

Best Regards

Lucien