Forum Discussion

ustas55's avatar
ustas55
Helper II
6 years ago
Solved

Compound RLS

Good Day Professionals, I'm relatively new to Power BI, so please excuse my basic (if that) question. Looking for advice on how to achieve/implement dual RLS mode. In my simple example, let's say ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi ustas55 ,

     

    Please refer to my .PBIX file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

ustas55's avatar
ustas55
Helper II
6 years ago

Hi Lionel,
Unfortunately no, still pursuing opportunities on how to make it work.

My tables are as follow:

 

Just want to reiterate what I’m trying to achieve…. This RLS should accommodate reps who are currently assigned to a customer and reps that made transaction; “master data” vs “transactional”.

Rep-1 has 1 customer and 1 transaction. $100 should be returened using both RSL methods.

Rep-2 has 1 customer and 2 transactions. So if Rep-2 needs to see “master data”, he should see only $200. If he wants to see transactional, he would see $500.

Rep-3 has 1 customer and no transactions. So he should only see $300 associated with customer “C”. Since Rep-3 didn’t have any transactions, his “transactional” report should not display any numbers.

 

Thank you for looking into it.

Best Regards,

Sam

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi ustas55 ,

 

Please refer to my .PBIX file.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • ustas55's avatar
    ustas55
    Helper II
    6 years ago

    Thank you Lionel, 

    I think it will work. At least I've got a concept.

     

    Best Regards,

    Sam