Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
raul_pavel
Regular Visitor

Cannot find table

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_0-1619864628994.png

 

1 ACCEPTED SOLUTION
raul_pavel
Regular Visitor

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.

 

View solution in original post

3 REPLIES 3
raul_pavel
Regular Visitor

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.

 

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
Solution Sage
Solution Sage

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.