Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

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

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
4 years ago
or you can try:
converts = COUNTX( FILTER(Sheet1, NOT(ISBLANK(Sheet1[converted_date])) ) , COUNT([trail id])

technolog
Super User
4 years ago
or you can try:
converts = COUNTX( FILTER(Sheet1, NOT(ISBLANK(Sheet1[converted_date])) ) , COUNT([trail id])
technolog
Super User
4 years ago
Hi!
You can try:
converts = CALCULATE(COUNT(Sheet1[converted_date]), NOT(ISBLANK(Sheet1[converted_date]))
technolog
Super User
4 years ago
Anonymous is it worked? Do you need any help?
- Anonymous
  Not applicable
  4 years ago
  technolog Its worked . thanks for your support ..