Search code examples
powerbidaxpowerbi-desktopmeasure

Filtering rows if the text (string) match in Dax


How to filter my.data if my.data[column] contains "ABC" in DAX. Many thanks in advance.


Solution

  • Measure = CALCULATE(COUNTROWS('my data'), FILTER('my data', SEARCH("abc", 'my data'[column],1,BLANK()) >0))
    

    enter image description here