Forum Discussion
Anonymous
6 years agoNot applicable
Finding the distinct IDs from filtered data
Measure Trainees Completed Course = CALCULATE ( COUNTROWS(Training), FILTER ( Training, SEARCH ( "Completed", Training[Status],, BLANK () ) > 0 || SEARCH ( "Complete", Training[Status],, BLANK...
- 6 years ago
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 ) ) - 6 years ago
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?
amitchandak
6 years agoSuper 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
)
)Anonymous
6 years agoNot applicable
Yes it worked, thank you!