Countif Query Power BI

[Anonymous]

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

[Anonymous · Accepted solution]

New Measure
CALCULATE( COUNT('Table'[Column]), find("textA" , 'Table'[Column],1,0) > 0 )

[Anonymous]

Thanks It worked !