Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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))
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))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |