Forum Discussion

Jordan97270's avatar
Jordan97270
New Member
3 years ago
Solved

Connecting 4 tables

  In the first picture you can see my dataviz. In the second, you can see in red my filter, and in blue what change (that I want). But in the last dataviz picture you can see no co...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Jordan97270 ,

     

    Please try the userelationship() function to activate the inactive relationship.

    like this:

    Measure 3 = CALCULATE(MAX('Table (2)'[nom]),USERELATIONSHIP('Table (3)'[id_peloton],'Table'[id_peloton]))

    Best Regards,

    Neeko Tang

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Jordan97270 ,

 

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) My model relationship is as follows:

(3) Then the result is as follows.

Please refer to the following document for more information.

Model relationships in Power BI Desktop - Power BI | Microsoft Learn

Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

Active vs inactive relationship guidance - Power BI | Microsoft Learn

 

Best Regards,

Neeko Tang

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

Jordan97270's avatar
Jordan97270
New Member
3 years ago

Hi Anonymous ,

Thanks for your help.

But with your way the top table is not correct. Because delete peloton doesn't connect to a commandant.