This content has been marked as final.
Show 3 replies
-
1. Re: Count of users that watched every show?
Ken Flerlage Nov 30, 2018 9:48 AM (in response to Edward McKeown)Start by creating an LOD to calculate the number of distinct shows each user watched:
Shows Watched
// Number of distinct shows watched by each user.
{FIXED [User]: COUNTD([Show])}
You can then create 5 measures, 1 of 5, 2 of 5, etc. that checks the number of of shows watched. For example, here is 1 of 5:
1 of 5
IF [Shows Watched]=1 THEN
1
ELSE
0
END
Then you can build a view as follows:
See attached.
-
Shows.twbx 15.7 KB
-
-
2. Re: Count of users that watched every show?
Edward McKeown Dec 7, 2018 3:21 AM (in response to Ken Flerlage)Thanks for this!
-
3. Re: Count of users that watched every show?
Ken Flerlage Dec 7, 2018 5:36 AM (in response to Edward McKeown)If that answers your question, would you be so kind as to mark my response as the "correct answer" so that we can close this thread and others can quickly find the answer? Thanks!