count filter if contains text - measure

[sullynivek]

Hi all,

I have this measure that looks for closed work orders by a specified date i.e.

Closed = CALCULATE(COUNT(wkaw[cmpl_date]), USERELATIONSHIP(DateCalendar[Date],wkaw[cmpl_date]))

What I want to do is the following, the raw data consists of the work order number [wo] where there can be 3 different types of work orders; the different types start with 'C' , 'P' or 'T'. How can i filter so i can have 3 measures closed p jobs , closed c jobs and closed t jobs?

I have tried the following:

Closed C Jobs = CALCULATE(COUNTA(wkaw[cmpl_date]), FILTER('wkaw',FIND("C", wkaw[wo],,0)))

But this calculation for all 3 work orde types dont tally to the closed total amount.

Any help would be greatly appreciated

Thanks

Kevin

[sullynivek · Accepted solution]

For anyone that is interested the soluion is as follows:

CALCULATE(COUNT(wkaw[cmpl_date]), USERELATIONSHIP(DateCalendar[Date],wkaw[cmpl_date]), FIND("C", wkaw[wo],,0))