Countif Query Power BI

Hi,

I am new to power BI, need some sort of solution.

As we use Countif in excel with * to Count occurrence of some text like.

Cell1 TextA

Cell2 TextA,TextB

Cell3 TextB

and if I Use Countif(Cell1:Cell3,"*"&"TextA"&"*") it will give result 2 as in Excel.

is there any way around to do same in Power BI

Thanks in Advnace !

Regards