The WHERE clause here filters on the ProductID 1, which is the ID of the product Oranges. Now if you add the measures ‘Pear Sales’ and ‘Grapes Sales’ to the table visual: …and run the query in DAX ...

Good afternoon, and thank you for joining us today. On the call with me are Satya Nadella, Chairman and Chief Executive Officer; Amy Hood, Chief Financial Officer; Alice Jolla, Chief Accounting ...