topic Re: Cannot find table in DAX Commands and Tips

Cannot find table

raul_pavel — Sat, 01 May 2021 10:33:36 GMT

Hello,

I'm trying to create a measure, by using the `calculate function` and using a filter (see picture attached).

Unfortunately, it sems that the DAX command cannot find the data i'm using as a filter. I've browsed the forum already. I've tried changing the name of the table, but with no success. I've checked for errors in Power Query and found nothing there either.

The data can be found here - https://1drv.ms/u/s!AgmLz8-VbNGdkrFftzjfzlvpjxConw?e=mimfbn

thanks,

raul

Re: Cannot find table

daxer-almighty — Sat, 01 May 2021 10:53:16 GMT

Each field of human knowledge has its own set of rules and tools. You have to know them thoroughly to do things you want to do correctly. What a cliche... Please get familiar with CALCULATE and how filters work: Filter Arguments in CALCULATE - SQLBI

Re: Cannot find table

raul_pavel — Sat, 01 May 2021 11:11:18 GMT

Thanks for the quick reply.

I found the solution and it had nothing to to with the calculate function.

I was not using the right quotation marks.

Re: Cannot find table

daxer-almighty — Sat, 01 May 2021 11:29:45 GMT

Hm... From the picture you've placed in here it looks like you did use the right quotation marks... because I thought you wanted to use a table and then a column in it. For a table the single quotation marks are correct. But now I see you wanted to use a text value. OK. Confusing.