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