Forum Discussion
Solved
Power BI - help calculate Incident Resolution
PowerBI Looking for help to calculate monthly Incident Resolution in PowerBI. Need to filter on Priority and Duration both. Any suggestion would be helpful. Thanks
e.g Calculate percent of P3 resolved in less than 8 hours, Ref data:
| Number | Priority | Duration |
| IC28866 | 3 | 8.01 |
| IC28867 | 2 | 2.01 |
| IC28868 | 3 | 7.01 |
| IC28902 | 3 | 6.02 |
| IC28967 | 2 | 1.01 |
| IC29044 | 3 | 9.00 |
| IC29059 | 4 | 4.05 |
| IC29089 | 4 | 10.01 |
Hi lanand_73 ,
In DAX, the measure you need would be something like this:
_resolved% = VAR __noofInc = DISTINCTCOUNT(yourTable[Number]) VAR __noofIncAllExc = CALCULATE( DISTINCTCOUNT(yourTable[Number]), ALLEXCEPT( yourTable, yourTable[Priority] ) ) RETURN DIVIDE(__noofInc, __noofIncAllExc, 0)This will allow you to filter on [Priority] and use a slider for [Duration] to set the parameters for calculation:
Pete
2 Replies
Hi lanand_73 ,
In DAX, the measure you need would be something like this:
_resolved% = VAR __noofInc = DISTINCTCOUNT(yourTable[Number]) VAR __noofIncAllExc = CALCULATE( DISTINCTCOUNT(yourTable[Number]), ALLEXCEPT( yourTable, yourTable[Priority] ) ) RETURN DIVIDE(__noofInc, __noofIncAllExc, 0)This will allow you to filter on [Priority] and use a slider for [Duration] to set the parameters for calculation:
Pete
Sorry for late reply but really thank you for the solution. It was quick and helpful 🙂
