Forum Discussion
Filter Dataset by Secondary Column Only
I'm trying to figure out how to filter a dataset to by a secondary column only. In Excel the non-optimal workaround is to have two slicers (eg. one for store and one for product and after selectin...
So far I've been able to still return the total number of Product Sales for all Store's while only showing products for the selected store by using Measure = Calculate(sum(Table[Sales]),all(Table[Stores])) but have not been able to have the other relevant Stores appear in the table.