Forum Discussion

jengnz's avatar
jengnz
Frequent Visitor
3 years ago
Solved

Help with Dax

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 b...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi jengnz 

    please try

    SUMX (

    VALUES ( 'Table'[Case Number] ),

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

    )

jengnz's avatar
jengnz
Frequent Visitor
3 years ago

Worked perfectly! Thanks