Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
  • amitchandak's avatar
    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
    )
    )
  • vanessafvg's avatar
    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?