Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Is there anyway to disable RLS for a measure. I have active (B) and inactive (A) relationships in my model. In order to make a caclculation(measure) I have a measure where I deactivate a relationship (B) and activate another (A) using crossfilter and userelationship respectively.
This is my model. I have marked the relationships that create the two paths with A and B.
It appears to me that the path of B is not disabled which I thought would be the case with the crossfilter statement in the measure.
Any suggestions on how this can be done?
Are the security filters applied in both directions between the General Ledger table and the dimensions pointing at it? Why the bidirectional joins there?
Thanks for the response. I have bi-directional joins to look up data in both directions. But I still get this error when I using relationships in the single direction. I change the model to test.
This is an example of my relationship to GL Leger. Since I'm using 1 to many the box for security filter in both directions does not show up.
| User | Count |
|---|---|
| 53 | |
| 40 | |
| 35 | |
| 24 | |
| 22 |
| User | Count |
|---|---|
| 134 | |
| 107 | |
| 57 | |
| 43 | |
| 38 |