Cannot find table

[raul_pavel]

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

[raul_pavel · Accepted solution]

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.

[daxer-almighty]

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.

[daxer-almighty]

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