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 ...
XDA Developers on MSN
Here are all the new features Microsoft added to Excel in January 2026
Excel gets a host of new features in January 2026 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results