Countifs in DAX

Hi Spartanos ,

According to your description, here's my solution.

Create a measure.

 

Performance =
VAR _CY =
    COUNTROWS (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Tracking] = MAX ( 'Table'[Tracking] )
                && 'Table'[Week] = MAX ( 'Table'[Week] )
                && 'Table'[Country] = MAX ( 'Table'[Country] )
                && 'Table'[On-time-check] = "yes"
        )
    )
VAR _C =
    COUNTROWS (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Tracking] = MAX ( 'Table'[Tracking] )
                && 'Table'[Week] = MAX ( 'Table'[Week] )
                && 'Table'[Country] = MAX ( 'Table'[Country] )
        )
    )
RETURN
    DIVIDE ( _CY, _C )

 

Get the correct result.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

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