Multiple Column Relationship- Power BI Data Model

[smtiwari]

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?

[v-diye-msft · Accepted 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

[v-diye-msft · Accepted 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

[smtiwari · Accepted solution]

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.