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
91asma2
5 years agoHelper I
Hi daxer,
Yes, my model is a star schema.
Anonymous
5 years agoNot applicable
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