Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I'm trying to understand the relationship of Power bi, I created an app that has two facts, with some dimensions.
I simply put the dimensions together for the facts, but when I created my measures, I used the crossfilter for all dimensions, because I need to show in the same table data from PB L(fact1) and PB O(fact2), that is correct?
Is CCC your RLS table? Or are the rules applied elsewhere?
[Login] cannot be used as an RLS table as it sits on the Many side of a relationship, and has a search filter pointing its way - that means none of its rules will ever impact anything.
First of all, thank you for your answer..
The CCC table is my dimension, which contains CC, this field has a relationship with Login. My login table has a username and which CC (department) this user has access.
The rules are applied in the CCC table.
I would like to understand if, my measures its correct, with a lot of cross filter and how to solve the RLS
Thank you
Hi, someone can help me, with this scenario?
Thank you
@Greg_Deckler
@amitchandak
@ImkeF
@Fowmy
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |