Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

ALL function not working

Hi!   I am trying to utilize the ALL function in a real life scenario, but it dosen't seem to work. I have a data model in which I have added a calculated column to see how far a list of around 60...
Need Help
PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

What is the structure of the model and the table?
In the following example, with this sample table

and these measures

Average Points = AVERAGE('fTable'[Points])
All = CALCULATE(AVERAGE(fTable[Points]), ALL(fTable))

I get

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    The table is very similar to the one you have. Here is a picture of the calculated column: 

    On each row there is also a column for team, team group, and an area, but with other names I can't share. 

     

    As you can see the data model consists not only of 0% values, but also 25%, and 75%. No team has come to 50% or 100%, that's why those values don't exist. 

     

    I've made the exact same formulas as you have written now. These are the results:

    It looks promising! When I copy and paste the same matrix onto another page with a page level filter for a special team group, it looks like this:

    Now all of a sudden, it shows the average progress for the team on both the average AND the ALL value! This is what I don't want. I want the ALL value to still display 6,87% which is the average across all teams in the company. 

     

    Any way to solve this?

     

    BTW, the page with a page-level filter is reached by using drill through.