Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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.
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.
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
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |