DAX Matching Any String of Zero or more characters

[Anonymous]

Hello,

I'm creating a Metric. I need to use a CALCULATE formula where Im doing a DISTINCTCOUNT of a filtered table. The thing is that the filter is conformed by many different string codes "A1.01", "A1.02", "A1.03", etc.

Is there any shortcut to fetch all these variations with one line of code? Similar to Regex "A1.0%".

Metric1 = CALCULATE(DISTINCTCOUNT(Table[Column]), FilterTable[Code] = "A1.01" || FilterTable[Code] = "A1.02" || ...)

Thanks!

[HobbyS · Accepted solution]

Could you use LEFT(FilterTable[Code], 4) and the compare it to "A1.0"?