How to filter my.data if my.data[column] contains "ABC" in DAX. Many thanks in advance.
my.data
my.data[column]
"ABC"
Measure = CALCULATE(COUNTROWS('my data'), FILTER('my data', SEARCH("abc", 'my data'[column],1,BLANK()) >0))