Connecting 4 tables

[Jordan97270]

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

[Anonymous]

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]

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.

[Anonymous · Accepted solution]

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. 

[Jordan97270]

Thanks a lot