Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a question about defining multiple column relationship between 2 tables.I am defining RLS on UserProfile :
I want to filter Company on basis of User Profile table, combination of 3 columns- OrganizationId, ShopId and OfficeId
However, OfficeId can be null so in such cases, I have to only consider OrganizationId and ShopId for joining, so that in my report I am able to view all Offices for that OrganizationId- ShopId Combination.
Also making sure the filter propagates from many to one side , which is not happening? Any workarounds?
Solved! Go to Solution.
Hi @smtiwari
Do you mean you'd like to join the table by several columns in the table?
Plz kindly refer to below threads fror better practice:
https://community.powerbi.com/t5/Desktop/Join-tables-based-on-multiple-columns/td-p/277802
https://community.powerbi.com/t5/Desktop/Conditional-join-on-multiple-columns/m-p/688736
https://community.powerbi.com/t5/Desktop/Conditional-join-on-multiple-columns/m-p/1091757
Thanks @v-diye-msft for your response, I used the same method but I also had to tweak my data model for it to work.
Hi @smtiwari
Do you mean you'd like to join the table by several columns in the table?
Plz kindly refer to below threads fror better practice:
https://community.powerbi.com/t5/Desktop/Join-tables-based-on-multiple-columns/td-p/277802
https://community.powerbi.com/t5/Desktop/Conditional-join-on-multiple-columns/m-p/688736
https://community.powerbi.com/t5/Desktop/Conditional-join-on-multiple-columns/m-p/1091757
Thanks @v-diye-msft for your response, I used the same method but I also had to tweak my data model for it to work.