Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have this:
Solved! Go to Solution.
@NingMel try this:
WO with Code TF1 or TF2 =
COUNTROWS (
FILTER (
WORK_ORDER,
CONTAINS (
RELATEDTABLE ( EQUIPMENT ),
EQUIPMENT[EQUIPMENT_CATEGORY_CODE], "TF1"
)
|| CONTAINS (
RELATEDTABLE ( EQUIPMENT ),
EQUIPMENT[EQUIPMENT_CATEGORY_CODE], "TF2"
)
)
)
@NingMel try this:
WO with Code TF1 or TF2 =
COUNTROWS (
FILTER (
WORK_ORDER,
CONTAINS (
RELATEDTABLE ( EQUIPMENT ),
EQUIPMENT[EQUIPMENT_CATEGORY_CODE], "TF1"
)
|| CONTAINS (
RELATEDTABLE ( EQUIPMENT ),
EQUIPMENT[EQUIPMENT_CATEGORY_CODE], "TF2"
)
)
)
@SpartaBI Thank you so much it works!!! I knew it was something to do with this || but I never use it before. I tried below but it didn't work. Anyway thank you so much.
@NingMel my pleasure 🙂
Please don't forget to accept my previuos reply as a solution for community viasabilty and appreciate your kudos 🙂
User | Count |
---|---|
49 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
100 | |
55 | |
28 | |
18 | |
13 |