Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
142 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |