Sum two lines under conditions

LudwigGdn — Thu, 13 Jun 2024 09:30:02 GMT

Hi guys,

I am stuck on a problem,

I have different tables : DIM_Energy,DIM_Country, FACT_Energy_Mixed
In my table FACT_EnergyMixed, I have the following colum :

CountryCode : Contain the code of the country that refer to a country in DIM_Country

EnergyCode : Contain the code of the energy (gaz, electricity etc ...) that refer to a country in DIM_Energy. There is for each energy an indicator 'Y'/'N' to say if it's a clean or unclean energy

ValueEnergtMix: The value produce for an energy and a country for one year

Year: The years from 2000 to 2022

I try to find the pourcentage of evolution between 2000 and 2022 for the clean and for the unclean energy.

For now I tried two differents methods :

And I get that :

The thing is I would like that after the calcul of the pourcentage, it makes the sum of the value.
Fx, for France, it should do -29.70 + (-29,01) + 2857,23 = 2,798.52

I don't really understand how it does the calcul, but it's not what I want.

I tried also on the recommandations to chatgpt and it gave me that :

with Valeur2020 and Valeur2022 equal :

After that, it told me to filter on the country and the energy but I obtain the same problem.
Could anyone could help me ?

Re: Sum two lines under conditions

lbendlin — Fri, 14 Jun 2024 01:07:38 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

topic Re: Sum two lines under conditions in DAX Commands and Tips

Sum two lines under conditions

Re: Sum two lines under conditions