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,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.