Count values based on other column

[ajisharavind_99]

Hi,  

I hope someone can help me quickly find the answer to the below query

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Result CC =
IF (
    COUNTROWS (
        FILTER ( Data, Data[ID] = EARLIER ( Data[ID] ) && Data[Actions 1] = "Open" )
    ) > 0,
    0,
    1
)

[ajisharavind_99]

@Jihwan_Kim Thanks , Awsome !!