Forum Discussion

91asma2's avatar
91asma2
Helper I
5 years ago
Solved

Distinct Count Two Measures

  • Anonymous's avatar
    Anonymous
    5 years ago

    Here's what the measures should look like:

     

    [Follow up] =
    COUNTROWS(
        FILTER(
            VALUES( Assessment[User ID] ),
            CALCULATE(
                DISTINCTCOUNT( Assessment[assessment_id] ) >= 2
            )
        )
    )
    
     
    [Total Users Training] =
    CALCULATE(
        DISTINCTCOUNT( 'Sessions'[User ID] ),
        KEEPFILTERS( 'Sessions'[Event Category] = "Training" )
    )
    
    [Users in Both] =
    var FollowUpUsers =
        FILTER(
            VALUES( Assessment[User ID] ),
            CALCULATE(
                DISTINCTCOUNT( Assessment[assessment_id] ) >= 2
            )
        )
    var TotalUsersTrainingUsers =
        CALCULATETABLE(
            DISTINCT( 'Sessions'[User ID] ),
            KEEPFILTERS( 'Sessions'[Event Category] = "Training" )
        )
    var Result =
        COUNTROWS(
            INTERSECT(
                FollowUpUsers,
                TotalUsersTrainingUsers
            )
        )
    RETURN
        Result