cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Simple multiply between to fields without direct releation

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 (* *).

Seby

1 ACCEPTED SOLUTION
New Member

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
2 REPLIES 2
Community Champion

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

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

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