Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
78 | |
62 | |
61 | |
59 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |