Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Matching Any String of Zero or more characters

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!

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

1 Reply

  • HobbyS's avatar
    HobbyS
    Regular Visitor

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