Forum Discussion
Aggregation by Threshold
Hi,
My dataset contains a list of IT Controls and their Pass/Fail status for a number of servers. The format is something like:
| IP | Control ID | Status |
| 10.10.0.1 | 1001 | Fail |
| 10.10.0.1 | 1002 | Fail |
| 10.10.0.1 | 1003 | Pass |
| 10.10.0.1 | 1004 | Pass |
| 10.10.0.2 | 1001 | Pass |
| 10.10.0.2 | 1002 | Pass |
| 10.10.0.2 | 1003 | Pass |
| 10.10.0.2 | 1004 | Fail |
etc.
We would like to have a pie/donut chart showing what percentage of controls passed at least 95% of the time (the holy grail would be to use a slicer to be able to modify that 95% figure!).
Is this something that Power BI can even do?
rk761651 see attached file, just focus on page 9/table control that has your sample data. There are other tables in the report, for some other solutions, you can ignore those.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡
5 Replies
Looks like it!
rk761651 see attached file, just focus on page 9/table control that has your sample data. There are other tables in the report, for some other solutions, you can ignore those.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡
Really appreciate that. Thank you.
Can you explain how [Pass %]Pass % is generated/calculated?
it is a what-if parameter?
