Making a dinamic filter with dax

Hi Jagerrrr1234 

Before you even start to think about a Power BI project, I would strongly recommend that you first of all create a proper model. This means strictly no models with one table. There are too many reasons (and horror stories) to state here why this should be so. If you want to know how to build a good correct model in PBI, please read this: Understand star schema and the importance for Power BI … (bing.com)

One-table models are known for issues that can't be resolved when they hit and sadly, you never know when they do. So, please for your own sanity and correct figures create a good model. Then it'll be much easier to reason about it and create correct measures.

Once you've got a good model...

If you want to exclude stores that have at least one month where a measure is blank, then you have to create an informational measure in which you'll iterate over all the months in scope (using ALLSELECTED) and calculate the number of months where the measure is blank (for the store in context). If the number is > 0, then you return 1, else 0. Then you use this helper measure in the filter pane of the visual to filter out such stores.