Clarification on Total Calculation (Columns)

[alloja]

Hello,

I find it hard to understand.
See the screenshot:

CombiExo =

IF(MAX('Liste Energie'[famille.energie]) = "Polluant", [PAx€CV] * [Valeur exo_polluant],

IF(MAX('Liste Energie'[famille.energie]) = "Hybride", [PAx€CV] * [Valeur exo_hybride],

[PAx€CV] * [Valeur exo_propre]))

I've already used SUMX, and the result is the same.

The total is calculated: 120 M * 10% (exo_propre) = 12M but I'd like the total to add up in the column as 97,71M + 9,27M + 0,38M.

I'm a beginner. Thanks for your help.

[Sergii24 · Accepted solution]

Hi @alloja, the answer to your problem lays in the concept of "Row context". 

If you're new to PowerBI, make sure to decicate some time for learning concepts in this playlist - DAX 101 from SQLBI. Especially these 2: https://youtu.be/Nm9x83J-SBk?si=oVVd3_lFypu_tzxI and https://youtu.be/lX2ztEh3tuA?si=zLq5dT3GG6KggNCq. It will save you dozens of hours later, believe me 😉

Good luck!