cancel
Showing results for
Did you mean:
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

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors