topic Re: Count values based on other column in DAX Commands and Tips

Count values based on other column

ajisharavind_99 — Tue, 13 Dec 2022 07:27:13 GMT

Hi,

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

Jihwan_Kim — Tue, 13 Dec 2022 07:36:46 GMT

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 — Wed, 14 Dec 2022 04:07:15 GMT

Jihwan_Kim Thanks , Awsome !!