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