Forum Discussion
Counting iteration under a category- count if (containsstring)/match
Hi, Thank you for reviewing my questions. I've been tackling a problem in BI, but I haven't had much luck. I am working with a model that analyzes student completion rate. Students can ...
I've tried the following code:
Transfer in count across =
CALCULATE(
COUNTROWS(new_pos),
FILTER(
new_pos,
new_pos[Exitdatekey] = EARLIER(new_pos[ScheduledCohortGradDateKey]) &&
(
new_pos[GradStatus] = "Graduated Early" ||
new_pos[GradStatus] = "Graduated Late"
) &&
new_pos[new_degreeabbreviation] = EARLIER(new_pos[new_degreeabbreviation])
)
) + 0
Grad status has more fields so I filtered for Graduated Early and Graduated Late, but the values are a little off. But very close
what's the problem now? could you pls update the sample data which does not meet the expected output?