Forum Discussion

ajisharavind_99's avatar
ajisharavind_99
Advocate I
3 years ago
Solved

Count values based on other column

Hi,   I hope someone can help me quickly find the answer to the below query            
DAX
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

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
)