Forum Discussion
Anonymous
3 years agoNot applicable
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
- HobbySRegular Visitor
Could you use LEFT(FilterTable[Code], 4) and the compare it to "A1.0"?