Forum Discussion

twister8889's avatar
twister8889
Helper V
5 years ago

Relationship two Facts ( crossfilter ) and RLS

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?

Real = CALCULATE(
SUM('PB L'[R Values]),
CROSSFILTER('PB L'[CC], CCC[D CC],Both),
CROSSFILTER('PB L'[CCA R], CCA[D CA] ,Both),
CROSSFILTER('PB L'[Data R], Data[Data ],Both)
)

I don't know why the relationship BOTH in Model View tables, is not recommended, but inside the measure, it's recommended.
Can you please give some help/feedback to improve the relationship?
I have an error when I selected one user in my RLS table that not has data on facts ( G 7 doesn't have information in facts PB L, is not a 188 to Real values ). I have an alternative to this RLS table (Login)?
I need to show the Name from Login table in my report after that the RLS.

 
 
 
My pbix and data source is here:

 
 
 

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    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.

    • twister8889's avatar
      twister8889
      Helper V
      5 years ago

      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