Solved: Connect two table

Elie_HUCHET · ‎06-02-2022

Hello, I would like to relate two tables through a single column. I would like that when there is a skip (0 or less) in the "Chartre de Bretagne" agency.

The code is:

Bennes manquantes (réparation, achat,... = 
IF(CALCULATE(sum('Stock pour Echange'[Stock pour dev Co])-[Nb stock dispo (opé - dédié - éch - résa)])<1,"",CALCULATE(sum('Stock pour Echange'[Stock pour dev Co])-[Nb stock dispo (opé - dédié - éch - résa)]))

Then all the agencies where there are skips are displayed with the number but on another tab.
If you need more information do not hesitate to come back to me.

Have a good day 🙂

v-yanjiang-msft · ‎06-05-2022

Hi @Elie_HUCHET ,

Sorry for not very clear about your problem, is your main problem not getting the correct result when there are two tables in the measure? If this is the case, please provide more details about the two tables, are they have relationship in the data model?

Best Regards,
Community Support Team _ kalyj

View solution in original post

v-yanjiang-msft · ‎06-05-2022

Hi @Elie_HUCHET ,

Sorry for not very clear about your problem, is your main problem not getting the correct result when there are two tables in the measure? If this is the case, please provide more details about the two tables, are they have relationship in the data model?

Best Regards,
Community Support Team _ kalyj