Question
I would like to calculate the completion rate (a percentage) by counting rows that meet several conditions in Power BI. The sample data is below:
I would like to calculate the completion rate (a percentage) by counting rows that meet several conditions in Power BI. The sample data is below:
| Index | Module 1 | Module 2 | Module 3 | Module 4 | Score |
| 1 | 1 | 0 | 1 | 0 | 82% |
| 2 | 1 | 1 | 1 | 1 | 76% |
| 3 | 0 | 0 | 1 | 0 | 100% |
| 4 | 1 | 1 | 1 | 1 | 98% |
| 5 | 0 | 1 | 1 | 0 | 67% |
I would like to count the number of rows where all the modules = 1 AND the score is greater than 75%. So in this case, the completion rate would be 40% since only 2 people completed all modules (1 = completed) and had a score greater than 75%.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
SQL Server 2019 Administrator S Guide A Definitive Guide For DBAs To Implement Monitor And Maintain Enterprise Database Solutions
Authors: Marek Chmel ,Vladimir Muzny
2nd Edition
1789954320, 978-1789954326
