Forum Discussion
91asma2
5 years agoHelper I
Distinct Count Two Measures
- Anonymous5 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