Return Text column based on other column condition
Hi, I'm a noobie to DAX and need help. I have a table with product names and store wise sales.
I want to see a visual matrix table where the prodnames should be displayed if either store 1 or store 2 has sales. If there's no sale in either of the store for that prodname, it shouldn't appear in the table. Please help me how to do this.