Wrong dax formula in Power BI

[Analitika]

Hello having wrong error syntax dax, how fix it?

[v-yingjl · Accepted solution]

Hi @Analitika ,

The error would happen in here based on the error message. ContainRows() is the same with IN.

Seems like the type of your [SAS_KOD] column is text while 20210 is a number type.

You can write the formula like this:

[SAS_KOD] in {"20210"}

or use '=' directly to compare since there is only one value to search and compare:

[SAS_KOD] = "20210"

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM]

Hi @Analitika 

Check the type of columns you used in the formula. 

Appreciate your Kudos!!