Average with Keep filter and keep filter showing same value.

[Anonymous]

Hi experts,

Note: I am looking for what wrong I am doing and bit of explanation or links to the solution so I can learn.

I am not quite sure but my average keep filter and remove filter shows same value. 

I have written some measure on the test sample: 

1. avgnofilter: I used remove filter on table and columns and tried but this and 

avgNoFilters = DIVIDE(Agegroup[FilCount],CALCULATE(Agegroup[TotalCount],REMOVEFILTERS(Agegroup)))

2. avgNoAgeGrooupFilter: I wanted a measure for average of selected column 

avgNoAgeGroupFilter = DIVIDE(Agegroup[FilCount],CALCULATE(Agegroup[TotalCount],KEEPFILTERS(Agegroup)))

TestAverage.pbix 

Source File Table (.XlSX) 

Unfortunately Both results show same answer, I think I am making some mistakes 

What I want is Avg of selected column for over all column with no filters 

Example:

1. Average of selected column say Age range: 10-20 Y, I am looking for average of this across age groups 

2. when I add a country to the filter, when I select say Brazil, i need the average of Brazil, with that age group against over all average NO filters at all.

3. Same as 2 but I need average of selected items average of Brazil for all age groups. 

thank you for your help. 

[Icey · Accepted solution]

Hi @Anonymous ,

Is this what you want?

avgNoFilters 2 = DIVIDE([FilCount],CALCULATE( COUNT(Agegroup[ID]),ALLSELECTED( Agegroup[Age group])))

avgNoFilters 3 = DIVIDE([FilCount],CALCULATE( COUNT(Agegroup[ID]),REMOVEFILTERS( Agegroup[Age group])))

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.