Forum Discussion

Jfg's avatar
Jfg
Regular Visitor
3 years ago

Filtering doesn't work in every graphic

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?

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago
    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 :