Filter table using multiple tables

[Austen229022]

I have 3 tables that are linked together using bridge tables (as seen below).

What I am trying to do is to have columns in the DIM_Contact table being filtered by both the DIM_PractitionerClass (2 columns)  and DIM_Licence columns (1 column). This works to an extent though it does not filter all the data in the way that I need to.

What is the best practise for this? Do I need to have another bridge table to link DIM_PractitionerClass and DIM_Licence?

[rajendraongole1 · Accepted solution]

Hi @Austen229022 - Common bridge table that connects these dimensions in a many-to-many relationship context.

If filtering isn't working as expected, you might need a common bridge table to link DIM_PractitionerClass and DIM_Licence to DIM_Contact. you ensure that your data model is optimized for filtering the Dim Contact table based on multiple dimensions. This approach leverages a common bridge table and ensures that relationships are correctly established and cross-filtering works as expected. 

Ensure that cross-filtering is set to "Both" for these relationships to ensure proper filtering across the tables.

Try the above suggested changes and let's see. 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Austen229022]

Hi Rajendraongole1,

If I were to have the two standard bdige tables like I have now, and another joint bridge table wouldnt that cause cardinality issues?