Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |