Count with specific condition

Hi Asim,

I'd like to suggest you use below measure formula to instead.

Sample:

Count =
VAR filtered =
    COUNTROWS (
        FILTER (
            Eventlog,
            Eventlog[Date] > MAX ( Eventlog[Date] )
                && ( Eventlog[Machine_Material] ) = SELECTEDVALUE ( Eventlog[Machine_Material] )
        )
    )
RETURN
    IF ( filtered > 1, 0, 1 )

BTW, you can also use below formula if you had to use calculate column to achieve your requirement:

Count =
IF (
    CALCULATE (
        COUNTA ( Eventlog[Machine_Material] ),
        FILTER (
            ALL ( Eventlog ),
            Eventlog[Date] > EARLIER ( Eventlog[Date] )
                && ( Eventlog[Machine_Material] ) = EARLIER ( Eventlog[Machine_Material] )
        )
    )
        > 1,
    0,
    1
)

Regards,

Xiaoxin Sheng