Using a column from another Table

Hi Anonymous 

I thought DAX could not handle this situation, but after I studied your data structure again, I found that DAX can still handle it. 

The principle of DAX is to take the intersection with the red part in the figure, and then sum it.

Dax code:

test = //measure
    var _t1= SELECTCOLUMNS(FILTER(ALL(Tableau2),Tableau2[Année]=MIN(Tableau2[Année]) && Tableau2[Mois]=MIN(Tableau2[Mois])),"s",Tableau2[fourniseur + month])
return CALCULATE(SUM('Qtité_livré'[Nbre de commandes]),INTERSECT(VALUES('Qtité_livré'[Fourn. & Month]),_t1))

Best Regards,

Community Support Team _Tang

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