Getting Wrong in Total in Detail Table

[Shashi_Kant82]

Hi Community, I am encountering an unexpected outcome while utilizing a DAX query to perform calculations within a detail table. As illustrated in the attached image, the current DAX query is producing incorrect results. I kindly request assistance from the community in identifying and rectifying this issue.

[skparavind_1994]

Try this measure:

DIVIDE(SUM(Orders[Profit]),SUM(Orders[Sales]))
or
SUMX(Orders,SUM(Orders[Profit])/SUM(Orders[Sales]))

[Arun_kumar]

Try this in measure :
SUMX(Orders,Orders[Profit]/SUM(Orders[Sales])

[anmolmalviya05]

Hi @Shashi_Kant82, Please try below measure

Profit Ratio =
DIVIDE(
SUM(Orders[Profit]),
SUM(Orders[Sales])
)

[grazitti_sapna · Accepted solution]

Hi @Shashi_Kant82 ,
Please Use the Dax Statement Below

SUM(Orders[Profit])/SUM(Orders[Sales])

I hope the provided solution works for you

If I have resolved your question, please consider marking my post as a solution. Thank you!
A kudos is always appreciated—it helps acknowledge the effort and keeps the community thriving.