Filtering doesn't work in every graphic

[Jfg]

Good morning,

I've been struggling with filtering in my dashboard, as depending on which graphic i click, it does not filter the others.

The data comes from the same table. It has 3 columns: Country, Region and Population. The population info is at region level.

If the population is 0, it does not have to be considered.

As I want to show the average population of each country, i've created the following measure:

AVG POP = CALCULATE(([Pop avg France]+[Pop avg Germany]+[Pop avg Italy])/([Count regions France]+[Count regions Germany]+[Count regions Italy]))

Where:

Pop avg France = CALCULATE(AVERAGE(Sheet1[Population]),'Sheet1'[Country]="France")

Count regions France= IF((CALCULATE(sum(Sheet1[Population]),Sheet1[Country]="Germany")=0),0,1)

The problem is that if i click in the table (above) it updates every graphic. Whereas if i click in the pie graphic, it does not updated the bar graphic.

Could you help me please?

[lbendlin]

If the population is 0, it does not have to be considered.

Why?  That will skew the result.  Anyway, here is how you would do that :