Count based on the other column

[Anonymous]

I have table name called Leads data . this table  have a two column 

I  am  trying  Create a measure called converts which is count of trail_id where converted_date column is populated

converts = COUNT(Sheet1[date])

ID NO              date 

626238            

626231              August 26,2021      

636241

636564             August  28,2021

653234             August  29,2021

657634            August   30,2021

I want count of trail id where the converted Date populated .

Thanks in advance . looking for support .

[technolog]

@Anonymous is it worked? Do you need any help?

[Anonymous]

@technolog  Its worked . thanks for your support ..

[technolog · Accepted solution]

or you can try:

converts = COUNTX( FILTER(Sheet1, NOT(ISBLANK(Sheet1[converted_date])) ) , COUNT([trail id])

[technolog]

Hi!

You can try:

converts = CALCULATE(COUNT(Sheet1[converted_date]), NOT(ISBLANK(Sheet1[converted_date]))