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.
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.
Thank you very much Anonymous for your explanations, it solved my problem!
