Ignore row context only

[megm001]

Is it possible for a table visual to including a column that ignores the row context, while still retaining other visual filters?

For example, I have the following table with filters for month and company. I also have a column called grand mean, which shows the total mean in every row. 

 

Now, if I filter by either month or company, the grand mean should adjust as well, as shown below.

But all I'm getting right now is this:

Here's my function for Grand Mean...

Grand Mean =

   CALCULATE(

      SUM(Customers[Taste Rating]),

      ALL(Customers[Company]),

      ALL(Customers[Month Surveyed])

   )/

   CALCULATE(

      COUNT(Customers[Taste Rating]),

      ALL(Customers[Company]),

      ALL(Customers[Month Surveyed])

   )

All help is appreciated. Thank you!

[parry2k · Accepted solution]

with ALL(Customers[Company]) you are removing filter on the company field. 

I guess you want to calculate "Grand mean" on selected records, correcT?

if that is the case then try following

Grand Mean =
   CALCULATE(
      SUM(Customers[Taste Rating]),
      AllSelected(Customers)
   )/
   CALCULATE(
      COUNT(Customers[Taste Rating]),
      AllSelected(Customers)
   )

[megm001]

Yes!

Thank you!