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 ...
How to format filters so they match visualizations in Microsoft Power BI Your email has been sent Power BI offers a lot of formatting flexibility for filters, but it’s nice when those formats match ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results