Forum Discussion
Connecting 4 tables
PresentationFirst stepSecond stepConnecting
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 connection with the bottom table. Can I have help please?
| id_peloton | libelle_peloton | id_commandant |
| 5 | Bravo | 6 |
| 6 | Explorer | 2 |
| 7 | Eclair | 2 |
| 8 | Mercenaire | 5 |
| 9 | Bouteille | 5 |
| id_commandant | nom |
| 1 | Gui |
| 2 | Bernard |
| 3 | Jean |
| 4 | Arnaud |
| 5 | Jul |
| 6 | Carl |
| id_peloton | Id_commandant | isDelete | Nb_mission |
| 1 | 6 | 1 | 5 |
| 2 | 4 | 1 | 6 |
| 3 | 1 | 1 | 1 |
| 4 | 2 | 1 | 6 |
| 5 | 6 | 0 | 5 |
| 6 | 2 | 0 | 0 |
| 7 | 2 | 0 | 9 |
| 8 | 5 | 0 | 0 |
| 9 | 5 | 0 | 9 |
| id_peloton | id_commandant | id_secour |
| 5 | 6 | 1 |
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.
4 Replies
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.
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.
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.
