Tell DAX to respect the current filter context

[Anonymous]

Hello Guys,

We are using the COVID Data Set here to get the countries with popluation more than 50 million or 5 Cr ( India ) and the people vaccinated for that particular country.

So we created the measure to find the previous day for the latest date in the data set and filter the population to greater or equal to 50 million and used the table visual. 

 

The measure works how we need it to and now  we  want to drag the "people vaccinated" column to the visual and expect it to respect the current filter context and only show us the data for the mentioned countries but as we drag the "people vaccinated" column in the visual we get the following 

So if you see the above image , we also get the countries where the population is less than 50 million, we don't want that ,  just want Dax to give us the current filter context which is present on the visual.

How can we do that?

Thanks in advance

[MFelix · Accepted solution]

Hi @Anonymous ,

In this case your issue is with the fact that columns and filters impact the context of a measure, but a measure does not impact the context of a column.

Meaning that if you add a column to a visualization where you have a measure that is filtered that filter in the measure does not impact the column values this is because the measure is not a value in the database is calculated on the moment is called.

In this case you need to do one of two things or create a measure with the sum of the vacinated that are higher than the 50M or filter the visualization directly by that column.