I created this measure to test how context evaluation worked:
Go to Solution.
Hi @nemo ,
Keep Product in single quotes 'Product'.
It is giving an error because Product is one of the built in function in Power BI.
Please try it and let me know if that works for you.
View solution in original post
Please check whether you have relationship between Sales and Product tables, if that exist then only it will work, if not please create a relationship first then try.
Thanks @PoojaDarbhe for your quick response. The model did have a relationship between Product and Sales as shown below
Excellent. Thanks @PoojaDarbhe.
Intellisense seemed not that inteligent: it should have simply spelt out that Product was a reserved keyword 😉
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.