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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
schwinnen
Helper V
Helper V

Grand Total disregarding filters

I have pasted a picture of what I am trying to do that hopefully will help.  

The data is pretty basic.  I have a list of customers with required and missed events.  Required Events, Missed Events, % Missed are all measures.  When I place Customer on the table, I get the data broken out by each customer.  What I want to do now, however, is look at the impact each customer has on the total and I want to look at the top 5 most impactful.  

 

Basically, I want to know what the total % missed would be if a specific customer has zero missed events.  

As an example, looking at my top 5 table, you see that customer T has 584 missed events.  In column K, you see that Impact on Total is 1.2%.  

To get this, I took the total of column C (5722) and subtracted the missed events for Customer T (584) to get 5138.  I then divide 5138 by the total required events in column B (46877) and get 11%.  So the impact of these 584 missed events is 1.2% (12.2%-11%).  Simple enough to do in Excel, but I'm not sure how to do this in Power BI.  Any help would be appreciated.

 

schwinnen_0-1593458812762.png

 

4 REPLIES 4
parry2k
Super User
Super User

@schwinnen you just need to a measure for all missed events with the following expression and use this to calculate %

 

All Missed Events = 
CALCULATE ( [Missed Events], ALLSELECTED ( Table[Customer] ) )

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.



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.

Thank you @parry2k .  This works on the main table I created, but if I create a separate table with only the top 5, it still gives me the calculations based just on the top 5.  Is there something else I can add to the measure you provided to get it to calculate all?

In the example I provided, there are 46877 required events and 5722 missed events.  Customer T had 584 missed events, which impacted the overall by 1.2%.  

If I create a table showing the top 5 (see example), there are 15947 required events and 2495 missed events (I didn't calculate the totals of the top 5 in my example).  I still want the impact of Customer T to be based on the total events, so 1.2%.  However, in Power BI, the calculation is just based on the top 5 and not the entire population.

@schwinnen no idea what you mean, provide more context.



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.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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