Forum Discussion
Filtering and counting results based on variable date
Hi everyone, I'm currently looking to create a measure of how many courses users went on to complete on average after completing a specific course (e.g course 2 in the sample data below). I'...
Anonymous , Create a measure like
Measure =
var _course = "Course 2" //selectedvalues(Course[Course]) //use independent course table in slicer
var _date = maxx(filter(allselected(Table), Table[ID] = max(Table[ID]) && Table[Course] =_course ), [Date])
return
calculate(countx(values(Table[User]), calculate(count(Table[Course]), filter(allselected(Table), Table[ID] = max(Table[ID]) && Table[Date] > _date))))
Hi, Anonymous
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution.
If you still need help, please share a sample file and expected result here for further research.
Best Regards,
Community Support Team _ Eason