I'm starting with PowerBI and DAX and would like if some could give me a hand on the following. I'm creating a dashboard to follow-up SLA achivement depending on priorities but I don't know how can I determinate dinamically when a case has hit the first reponse or the resolution SLAs.
Following a table with some data to explain. The achivement columns should have a nullor 1 depending if the case has achieved the SLA timings according to the nexts tables.
This small table that should be counting cases by priority and also counting how many of them have achieved the SLA with a % of the total.
The same calculation for Responsiveness (First response)
Thanks so much for helping on this. Apparently it's working as I expected but just a couple of measures are not calculating on my side. They are:
with the following message: "A single value for column 'ClosedDate' in table 'Case' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.."
I'll check this along the day but looks fine to me. Only one last question.
The column 'Closed' is just counting cases from the period, but what if the cases were created in the past and closed now?
In September there are 150 cases logged and from those 140 closed, so 10 pending. That does not mean that in September only 140 cases are closed, there can be closed cases from past months (previous backlog). There can be more closed than logged cases.
Do you get my point? I don't think this has been taken in consideration when you define the 'Closed' column.