Forum Discussion
Automatically calculated sum is wrong
Hi matdub40
Are the two columns you created measures or calculated columns?
You can try this calculated column :
Valo_T40_TY = Y2_Sales[TY_Units]*CALCULATE(SELECTEDVALUE(Y2_Tarif[Sum_Price]))Original data :
Final result :
I have attached my pbix file , you can refer to it .
As for the three functions you mentioned, you can refer to the document I provided, which explains the three functions in detail.
https://radacad.com/sum-vs-sumx-what-is-the-difference-of-the-two-dax-functions-in-power-bi
https://dax.guide/hasonefilter/
https://community.powerbi.com/t5/Desktop/HASONEFILTER-in-DAX/m-p/453866
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello amitchandak,
No, there is the Y2_Sales table which contains the value "TY_Units" and the Y2_Tarif which contains the value "prix"
matdub40 This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Greg_Deckler I have read the information contained in the two links you sent me, so for my problem concretely I must do what? HASONEFILTER, SUMX, SUM ? I'm a bit lost...