Forum Discussion

megm001's avatar
megm001
Icon for Advocate II rankAdvocate 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 an...
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)
   )

     

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper 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)
   )

 

 

 

megm001's avatar
megm001
Icon for Advocate II rankAdvocate II
8 years ago

Yes!

Thank you!