Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
I have role based security applied in dataset with Bidirectional cross filtering on FactTable(factContract). I wanted to add another facttable(factAgreegateContractMonthly). I am facing two issues.1. I ge inactive join on second fact table , Since Bidirectional filter is applied on first fact table and other Dimensions. 2.If I remove bidirectional filter I have RLS applied on the table and the filter will nto work properly. Please suggest a solution
Hi @Vadivel,
Could you please share your pbix or the sample data to me?
Regards,
Frank
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 17 | |
| 11 |
| User | Count |
|---|---|
| 55 | |
| 53 | |
| 43 | |
| 36 | |
| 32 |