Making a dinamic filter with dax
Hi, I'm kinda new to PBI and i really need to solve the following problem: I have stock data of different stores to the last day of each month, but for some technical reason, there are a few record that has no data. It looks like this: I have a date slicer, but I also want to make a dinamic filter somehow (with respect to the date slicer) to filter out those store, where i don't have data for each month. Something like this: I tried to figure it out, but it doesn't work, and I dont even know if I'm on the right way... Here's my attempt: If I create a table with this code and return the StoreToFilter variable, this works as I expect, and returns the stores that has data for every monhts, but in the report, I can't figure it out, how to use it as a filter. I uploaded the dummy data here: https://docs.google.com/spreadsheets/d/1ArDbLjXZZLKo8oA6CJ6NJbY2l1zRAH0j7IdlR1SKTGo/edit#gid=0 I hope my explanation was clear, and thank you for the help in advance!
