Forum Discussion

Shashi_Kant82's avatar
Shashi_Kant82
Icon for Helper I rankHelper I
1 year ago
Solved

Getting Wrong in Total in Detail Table

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 produci...
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    1 year ago

    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.

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
1 year ago

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.