Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |