Forum Discussion
Percentage Calculation in Power BI
I need to calculate the percentage based on the number of programs with a "Yes" response and how many are planned or have a "No" response. However, the challenge is that each program consists of mult...
In my real data, i have total # number of programs = 45
- Out of 45 Programs , 37 Service Order Status Response = Yes:
- Out of 45 Programs , 16 Service Order Status Response = Under Assesment
- Out of 45 Programs , 3 Service Order Status Response = Planned
And if you take a percentahe then you will get the Chart I shared with you, In some senarios I have no so need to keep one sanario for it too
Also I have total # of programs are 45 , and if Yes are 37 then left over that should 45-37= *, Only 8 program should be in Planned or under assesmet status, and that what I am trying to figure our how to calculate thos correctly that the prog that are already have yes ststus should not be count again for other status