Grand Total disregarding filters

[Anonymous]

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.

[parry2k]

@Anonymous 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.⚡

[Anonymous]

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?

[Anonymous]

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.

[parry2k]

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