Simple multiply between to fields without direct releation

[Seby]

Hello,

I need your help to resolve a simple problem (I'm beginner) and escially to identify the best solution !

I want to calculate Tonne CO2  = Population[Nombre] * TonneCO2ParHab[Tonnes de CO2 Par Habitant].

You can see relationships here

The link between data is the Year (Année) AND the Country code (Code Pays).

If I want to add relationships for Année it's not possible (* *).

Thanks in advance and Regards.

Seby

[az38]

Hi @Seby 

try a column

Column = Population[Nombre] * lookupvalue(TonneCO2ParHab[Tonnes de CO2 Par Habitant]; TonneCO2ParHab[Année]; Population[Année]; TonneCO2ParHab[Code Pays]; Population[Code Pays])

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[Seby · Accepted solution]

It don't work with these cardinality values. But I have the solution : 

Tonnes CO2 = TonneCO2ParHab[Tonnes de CO2 Par Habitant] * CALCULATE(FIRSTNONBLANK(Population[Nombre];1);FILTER(Population;Population[Année] = TonneCO2ParHab[Année] && Population[Code Pays] = TonneCO2ParHab[Code Pays]))

Thank you @az38