Forum Discussion
Summing the max values correctly
- 1 year ago
Hi SeymaKalay,
Thank you for reaching out to the Microsoft fabric community forum. Thank you Jai-Rathinavel for your input on this issue.
After thoroughly reviewing the details you provided, I was able to reproduce the scenario, I have used it as sample data on my end and successfully implemented it.Dax Measure:
Correct Total = SUMX( SUMMARIZE( FILTER( AnswersTable, AnswersTable[col1] > 0 && AnswersTable[col2] <> "text" && AnswersTable[col3] <> "text" && LEFT(AnswersTable[col4], 2) = "ab" ), AnswersTable[IDcol], "MaxAmt", MAX(AnswersTable[Amount]) ), [MaxAmt] ) Wrong Total = CALCULATE( SUM(AnswersTable[Amount]), AnswersTable[col1] > 0, AnswersTable[col2] <> "text", AnswersTable[col3] <> "text", LEFT(AnswersTable[col4], 2) = "ab" )Output:
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi SeymaKalay,
I tried to implement a solution for your problem. Please find the attached pbix file.
Summing the max values correctly.pbix
Please let me know if you have further questions.
If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!
Best Regards,
Maruthi