Count Based on specific values in column

Hi alawode ,

You can write below measure for getting required output:-

Fault_Car = 
VAR _max =
    MAX ( Car_detail[Car] )
VAR result =
    CALCULATE (
        COUNTROWS ( Car_detail ),
        FILTER (
            ALL ( Car_detail ),
            Car_detail[Car] = _max
                && Car_detail[Model] = "fault"
        )
    )
RETURN
    IF ( ISBLANK ( result ), 0, result )

Output:-

As you can see total not showing correct so for that you need to write another measure:-

Corrected_total = 
SUMX (
    SUMMARIZE ( Car_detail, Car_detail[Car], Car_detail[Model], "Sum", [Fault_Car] ),
    [Sum]
)

Output:-

Note:- Both measure need to create to get a final ouput.

Thank you,

Samarth