topic Re: How to countrow with multiple values in DAX Commands and Tips

How to countrow with multiple values

NingMel — Thu, 23 Jun 2022 07:16:35 GMT

I have this:

WO with Code TF1 = COUNTROWS(

FILTER(

WORK_ORDER, CONTAINS(RELATEDTABLE(EQUIPMENT), EQUIPMENT[EQUIPMENT_CATEGORY_CODE] , "TF1") ))

WO with Code TF2 = COUNTROWS(

FILTER(

WORK_ORDER, CONTAINS(RELATEDTABLE(EQUIPMENT), EQUIPMENT[EQUIPMENT_CATEGORY_CODE] , "TF2") ))

I want to use just one command (combine them together). I want to count WO if it has EQUIPMENT[EQUIPMENT_CATEGORY_CODE] either TF1 or TF2. I tried below but it doesn't work.

COUNTROWS(

FILTER(

WORK_ORDER, CONTAINS(RELATEDTABLE(EQUIPMENT), EQUIPMENT[EQUIPMENT_CATEGORY_CODE] in { "TF1", "TF2" } ) ))

Any suggestions?

Re: How to countrow with multiple values

SpartaBI — Thu, 23 Jun 2022 07:57:18 GMT

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" ) ) )

Re: How to countrow with multiple values

NingMel — Thu, 23 Jun 2022 23:07:30 GMT

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.

EQUIPMENT[EQUIPMENT_CATEGORY_CODE] in { "TF' ,"TF2"}

Re: How to countrow with multiple values

SpartaBI — Thu, 23 Jun 2022 23:09:53 GMT

NingMel my pleasure 🙂

Please don't forget to accept my previuos reply as a solution for community viasabilty and appreciate your kudos 🙂