Forum Discussion
Computing Percentage Test Results (String) for a Certain Application (Category)
Anonymous not sure based on the sample data how you are getting 66%, the way you are calculating it should 3/5 = 60% ( sum of 3 pass rows and total rows = 5 ) how you are showing 2/3?
Also based on your data, how you expected your final test results to be the % you are showing? You have to be very clear about what you are looking for specifically when you are showing sample data the make sure your expected output is based on the sample data.
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thank you for the resource link.
I am getting 66% from my example reply to you. In that example, this would be the percentage for 1 application category
| Pass/Fail | 1 if Pass, 0 if fail | |
| Pass | 1 | |
| Fail | 0 | |
| Pass | 1 |
So in this example, I would have 2 passes and 3 total rows. So the calculation would be 2/3 (66%)