Forum Discussion
Count based on the other column
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 conve...
or you can try:
converts = COUNTX( FILTER(Sheet1, NOT(ISBLANK(Sheet1[converted_date])) ) , COUNT([trail id])
