Forum Discussion

Seby's avatar
Seby
New Member
6 years ago
Solved

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[Tonne...
Need Help
  • Seby's avatar
    Seby
    6 years ago

    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 
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
    Seby
    New Member
    6 years ago

    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