Forum Discussion
Clarification on Total Calculation (Columns)
Hello,
I find it hard to understand.
See the screenshot:
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.
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!
1 Reply
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!