Help with Dax

[jengnz]

Trying to figure out a measure to get the Case number and the Critical errors.  So I need Case Number 1 with 7 critical errors not 21 critical errors.  The Total Critical Errors column is the total but it is showing for each row.  Thank you

Case Number	Start date	Total Critical Errors	Total Non Critical errors
1	5/19/2023	7	11
1	5/19/2023	7	11
1	5/19/2023	7	11
2	5/18/2023	5	3
2	5/18/2023	5	3
3	5/19/2023	6	5
3	5/19/2023	6	5

[jengnz]

Worked perfectly! Thanks

[tamerj1 · Accepted solution]

Hi @jengnz 

please try

SUMX (

VALUES ( 'Table'[Case Number] ),

CALCULATE ( MAX ( 'Table'[Total Critical Errors] ) )

)