Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
107 | |
101 | |
38 | |
35 |
User | Count |
---|---|
149 | |
122 | |
76 | |
74 | |
52 |