Help with DAX

Hi ab00sa7i ,

I create the table as you mentioned.

Then I think you can create three calculated columns.

reason1 = 
VAR _max =
    CALCULATE (
        MAX ( 'Table'[number of repeted error with important degree] ),
        ALLEXCEPT ( 'Table', 'Table'[id] )
    )
RETURN
    CALCULATE (
        SELECTEDVALUE ( 'Table'[error type] ),
        ALLSELECTED ( 'Table' ),
        'Table'[number of repeted error with important degree] = _max
    )

reason2 = 
VAR _max =
    CALCULATE (
        MAX ( 'Table'[number of repeted error with important degree] ),
        ALLEXCEPT ( 'Table', 'Table'[id] )
    )
VAR _next =
    CALCULATE (
        MAX ( 'Table'[number of repeted error with important degree] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[id] = EARLIER ( 'Table'[id] )
                && 'Table'[number of repeted error with important degree] < _max
        )
    )
RETURN
    CALCULATE (
        SELECTEDVALUE ( 'Table'[error type] ),
        ALLSELECTED ( 'Table' ),
        'Table'[number of repeted error with important degree] = _next
    )

reason3 = 
VAR _min =
    CALCULATE (
        MIN ( 'Table'[number of repeted error with important degree] ),
        ALLEXCEPT ( 'Table', 'Table'[id] )
    )
RETURN
    CALCULATE (
        SELECTEDVALUE ( 'Table'[error type] ),
        ALLSELECTED ( 'Table' ),
        'Table'[number of repeted error with important degree] = _min
    )

Finally you will get what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.