Forum Discussion

Powerlearn_95's avatar
Powerlearn_95
Frequent Visitor
2 years ago

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 ...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

Powerlearn_95 

pls try this

Column = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Actual exit date]=EARLIER('Table'[student scheduled grad])&&'Table'[Graduation Status]<>"graduated on-time"&&'Table'[Degree]=EARLIER('Table'[Degree])))+0

Powerlearn_95's avatar
Powerlearn_95
Frequent Visitor
2 years ago

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

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    what's the problem now? could you pls update the sample data which does not meet the expected output?