cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Maleehah
Post Patron
Post Patron

Relationship tables and Dax question

Hi, 

 

So i've been trying to figure out my penetration calculation however its not been working. 

 

I've now realised that the two tables i am using do not have a direct link. but there is a joining table between the two which has helped to a certain extent.

One of my tables links to the date table but the other doesnt, when using the two in a dax measure the table which doesnt link to the date does not update when the date filter is being used. 

Is that bevcause the link to the date table via the other tabe is not sufficient enough?

 

below is what my model looks like 

main tables are cirlcled and rsm&dealeer table is the link between the two as it links dealers on both ends

Maleehah_0-1630931354534.png

 

1 REPLY 1
Ailsa-msft
Community Support
Community Support

Hi @Maleehah 

We assume that your two main tables are table 1 and table 2 .You create a direct link between Date table and table 1 . You can filter data in table 1 through the date table .You create a joining table between the two main tables and want filter data in table 1 and table 2 at the same time by the date table .

Then the problem is coming , can you filter table 2 by table 1 ? If you select certain values of table1, will table2 also be filtered ? So you need to check the filtering direction of the connection table to ensure that table1 can filter table2 through the connection table .

 

Best Regards

Community Support Team _ Ailsa Tao

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

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors