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 ...

Learning how to use Power BI is fairly easy, and if you’re lucky, the built-in features will provide everything you need to produce professional dashboards for end users. However, you’ll get more out ...