Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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 .
Solved! Go to Solution.
or you can try:
converts = COUNTX( FILTER(Sheet1, NOT(ISBLANK(Sheet1[converted_date])) ) , COUNT([trail id])
@THENNA_41 is it worked? Do you need any help?
or you can try:
converts = COUNTX( FILTER(Sheet1, NOT(ISBLANK(Sheet1[converted_date])) ) , COUNT([trail id])
User | Count |
---|---|
42 | |
27 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |