What is the COUNTIF counterpart in Power BI?

[Mee2105]

hello, 

What is the PowerBI counterpart of =COUNTIF, please?

in my excel file,  I am using =IF(COUNTIF([@Tags],"*mango*"), "yes","no")to pick out  the word 'mango' and of they are present mark them as 'yes', else 'no'.

Thanks in advance.

[Syk · Accepted solution]

That formula is for a measure, if you're creating a column with DAX you can leave out the MAX portion of that!

[v-rzhou-msft · Accepted solution]

Hi @Mee2105 ,

As far as I know, your code should mean that if data in [@Tags] contains "mango" then return "yes" else return "no".

You can try code as below to create a calculated column.

Column = IF(CONTAINSSTRING('Table'[Tags],"mango"),"yes","no")

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mee2105]

Thank you so much, this works

[Syk]

If you're just trying to count mangos, you can use calculate.

Mango Count = CALCULATE(COUNT('Table'[id]),'Table'[Tags] = "mango")

Calculate is a filter function that uses your second argument (in this case, 'Table' [Tags]="mango") to filter your first argument.
If you are trying to mark them yes/no, we could do that too it just depends on what you're looking for.

[Mee2105]

Also, why isnt it accepting =CALCULATE as a formula?

[Syk]

You need to put a name.

[Mee2105]

Thank you for the solution.

is there a way to mark them as 'yes' and 'no' in another column? 

[Syk]

Yes. It would look like

is Mango = IF(MAX('Table'[Tag])="mango","Yes","No")

[Syk · Accepted solution]

That formula is for a measure, if you're creating a column with DAX you can leave out the MAX portion of that!