Automatically calculated sum is wrong

[matdub40]

Hello,

I have a problem in Power BI that I don't understand.

I have a table Y2_Tarif that contains values like this:

stylecode prix code_tarif
000453-ET1 38,7 T40
000453-ET2 38,7 T40
00091-ET1 34,1 T40

I have a first formula which is :
Sum_Price:=CALCULATE(sum(Y2_Tarif[prix]))

And a second one which is: Valo_T40_TY:=([Sum_Price])*(Y2_Sales[TY_Units])
TY_Units is the number of units sold.

Opening my model in Excel or Power BI directly I get this :

The formula makes me Units * price.
But in the automatically calculated sum I find a huge number which is not the real sum.

For example this with Excel :

There should be a sum of 321 639.85€ but I get 46 256 976.99€. Same thing in Power BI:

I don't have many numbers, the sum doesn't add up to 8 108 209.20€. All the other sums are correct, like the Units sum but not this one.

I don't understand how to change this automatically calculated sum. And where can this large value come from? I have looked at my relationships between the tables and they look good.

Thanks for your help

[Anonymous · Accepted solution]

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.

[matdub40]

Thank you very much @Anonymous  for your explanations, it solved my problem!

[amitchandak]

@matdub40 , If they are from same table . Try a measure like

Valo_T40_TY:=sumx(Y2_Sales,[Y2_Sales[Price]*Y2_Sales[TY_Units])

[matdub40]

Hello @amitchandak,

No, there is the Y2_Sales table which contains the value "TY_Units" and the Y2_Tarif which contains the value "prix"

[Greg_Deckler]

@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

[matdub40]

@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...