Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 Co...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago
    New Measure
    CALCULATE( COUNT('Table'[Column]), find("textA" , 'Table'[Column],1,0) > 0 )
Anonymous's avatar
Anonymous
Not applicable
5 years ago
New Measure
CALCULATE( COUNT('Table'[Column]), find("textA" , 'Table'[Column],1,0) > 0 )
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks It worked !