Count substring in column

[Anonymous]

I am having an issue with trying to FILTER and COUNT value in column starting with the letter "AB", I tried COLUMN = "AB*" and COLUMN = "AB%" but both did not return any results, please help me.

COUNTROWS('database table'),
                    FILTER(
                        'database table', 'database table'[status] <> "Rejected" && 
                        'database table'[column] = "AB*"
                    )

[amitchandak]

You have search and contain string for that

COUNTROWS('database table'),
                    FILTER(
                        'database table', 'database table'[status] <> "Rejected" && 
                        search("AB",'database table'[column],,0)>0 
                    )

https://docs.microsoft.com/en-us/dax/search-function-dax

https://docs.microsoft.com/en-us/dax/containsstring-function-dax