Forum Discussion

megm001's avatar
megm001
Advocate II
8 years ago
Solved

Ignore row context only

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!

Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    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)
   )

     

     

     

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    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)
   )