March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
90 | |
86 | |
76 | |
49 |
User | Count |
---|---|
167 | |
149 | |
99 | |
73 | |
57 |