Forum Discussion
SeymaKalay
1 year agoFrequent Visitor
Summing the max values correctly
I am trying to sum up totals in powerbi table using the first code below. Eventhough the numbers are appering correctly row by row. I am seeing wrong sumx(). SUMX(SUMMARIZE(
FILTER(
...
- 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.
v-saisrao-msft
1 year agoCommunity Support
Hi SeymaKalay,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.