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 ...
For many people using Power BI, DAX is the thing that quietly holds them back from getting the most out of the tool. They build strong visuals, connect their data, maybe create a few basic measures — ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results