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.
I'm working on this and I know this is not right. I think I need to use Containsstring but I never use it before, seeking for some advice. Essentially I want to count WO with EQ code that has 'PFL' within its code. EQ code is long and 'PFL' can be included at anypart of it.
Number of WOs with EQ contain PFL =
Solved! Go to Solution.
@NingMel , Try like
calculate(COUNTROWS(WORK_ORDER),filter(RELATEDTABLE(EQUIPMENT), containsstring(EQUIPMENT[EQUIPMENT_CODE],"PFL")))
or
calculate(COUNTROWS(WORK_ORDER),filter((EQUIPMENT), containsstring(EQUIPMENT[EQUIPMENT_CODE],"PFL")))
@amitchandak Thank you so much, it works!! I use this one:
calculate(COUNTROWS(WORK_ORDER),filter(RELATEDTABLE(EQUIPMENT), containsstring(EQUIPMENT[EQUIPMENT_CODE],"PFL")))
@NingMel , Try like
calculate(COUNTROWS(WORK_ORDER),filter(RELATEDTABLE(EQUIPMENT), containsstring(EQUIPMENT[EQUIPMENT_CODE],"PFL")))
or
calculate(COUNTROWS(WORK_ORDER),filter((EQUIPMENT), containsstring(EQUIPMENT[EQUIPMENT_CODE],"PFL")))
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |