Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
megm001
Advocate I
Advocate I

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. 

 1.PNG

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

 

2.PNG3.PNG

 

 

 

 

 

 

 

 

But all I'm getting right now is this:


2-2.PNG3-2.PNG

 

 

 

 

 

 

 

 

 

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!

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

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

 

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

2 REPLIES 2
parry2k
Super User
Super User

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

 

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Yes!

Thank you!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.