Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
this did not work for you ?
CALCULATE (
distinctcount(Training[trainee id]),
FILTER (
Training,
SEARCH ( "Completed", Training[Status],, 0 ) > 0
|| SEARCH ( "Complete", Training[Status],, 0) > 0
)
)
@Anonymous not sure i quite understand what you asking, did you say you tried this
Measure Trainees Completed Course =
CALCULATE (
DISTINCTCOUNT ( [trainingid] ),
FILTER (
Training,
SEARCH ( "Completed", Training[Status],, BLANK () ) > 0
|| SEARCH ( "Complete", Training[Status],, BLANK () ) > 0
)
) but it didn't work? What are you trying to do?
Proud to be a Super User!
@Anonymous not sure i quite understand what you asking, did you say you tried this
Measure Trainees Completed Course =
CALCULATE (
DISTINCTCOUNT ( [trainingid] ),
FILTER (
Training,
SEARCH ( "Completed", Training[Status],, BLANK () ) > 0
|| SEARCH ( "Complete", Training[Status],, BLANK () ) > 0
)
) but it didn't work? What are you trying to do?
Proud to be a Super User!
this did not work for you ?
CALCULATE (
distinctcount(Training[trainee id]),
FILTER (
Training,
SEARCH ( "Completed", Training[Status],, 0 ) > 0
|| SEARCH ( "Complete", Training[Status],, 0) > 0
)
)
Yes it worked, thank you!
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |