Text = Text gives syntax error. When used before it didn't, can you solve the mistery?

[IAM]

Hello!

Maybe it is a weird bug because I have used this same DAX.

I want to count the rows where a text cell on a row in one table is equal to the text cell in another table.

I get a syntax error. Both columns are text columns, made in Power Query.

Please check out the file in table: calculate.

https://www.dropbox.com/s/drumqziixfdlogs/KPI%20Dashboard%20hulp%20rev1.pbix?dl=0

[PC2790]

Just replace Calculate with 'Calculate', it will work.

Power BI has an inbuilt Calculate function, hence you will have to explicitly tell Power Bi that it is a table named calculate.

[SpartaBI · Accepted solution]

@IAMI looked at the broken code:

You don't have ' ' wrapping the last calculate. It thinks it's the calculate fucntion.
Put ' ' around it like in the 2 others.

But more important, never call a table name like a DAX function name  🙂
Change the table name to a different name.

Showcase Report – Contoso By SpartaBI