Count of Rows, match part of text: using wildcards

[Anonymous]

I am trying to count the rows that contain a code, I need to match using wildcards:

The codes I need to count ares: X*S and IX*S, the actual codes in the data are XFS/XGS or IXFS/IXGS

This is my calculation: RESO= (CALCULATE(COUNTROWS('table1'), 'table1'[Code] = "X*S" ) + CALCULATE(COUNTROWS('table1'), 'table1'[Code] = "IX*S" ) 

The * and ? wildcard is not working

Any solution? Thanks in advance 

[Anonymous]

DAX does not have regular expressions, nor does it have wildcards.

Create a column in Power Query (not in DAX!) and put 1 in a row if the code matches your pattern and 0 if not.

The rule is that the above column should come to your model from the data source. This should not be calculated in DAX by any means for many, many reasons. Easy as that.

Once you have this column, your measure is simple:

SUM( T[MatchesPattern] )

Best
Darek