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])
technolog
Super User
Super UserHi!
You can try:
converts = CALCULATE(COUNT(Sheet1[converted_date]), NOT(ISBLANK(Sheet1[converted_date]))