Power BI - help calculate Incident Resolution

[lanand_73]

@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

[lanand_73]

Sorry for late reply but really thank you for the solution. It was quick and helpful 🙂

[BA_Pete · Accepted solution]

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