topic Containsstring command in DAX Commands and Tips

Containsstring command

NingMel — Thu, 23 Jun 2022 23:31:48 GMT

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 =

COUNTROWS(

FILTER(

WORK_ORDER, CONTAINS(RELATEDTABLE(EQUIPMENT), EQUIPMENT[EQUIPMENT_CODE],"PFL"

)))

Really appreciate some directions here. Thank you.

Re: Containsstring command

amitchandak — Fri, 24 Jun 2022 03:20:40 GMT

NingMel , Try like

calculate(COUNTROWS(WORK_ORDER),filter(RELATEDTABLE(EQUIPMENT), containsstring(EQUIPMENT[EQUIPMENT_CODE],"PFL")))

calculate(COUNTROWS(WORK_ORDER),filter((EQUIPMENT), containsstring(EQUIPMENT[EQUIPMENT_CODE],"PFL")))

Re: Containsstring command

NingMel — Fri, 24 Jun 2022 05:38:48 GMT

amitchandak Thank you so much, it works!! I use this one:

calculate(COUNTROWS(WORK_ORDER),filter(RELATEDTABLE(EQUIPMENT), containsstring(EQUIPMENT[EQUIPMENT_CODE],"PFL")))