Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Experts
I have been working on this issue to much and seem to have hit a total blank
I have a problem to calculate the % availability for a service based on the total downtime of all the minutes the service had incidents logged against it. The measure should accommodate for slicing the data based on Dates (FY hierarchy) or sites (not all sites have all services) or Priority etc.
I have calculated the total minutes each incident impacted the availability for every incident. (Calculated Colum)
Each site has different operational hours and the impacted minute calculation takes this into account (closed times do not count to the total).
I have a measure in the Pbix file included but this calculates incorrectly.
Perhaps someone can assist me.
https://drive.google.com/drive/folders/1MFnRLiB81PmtC5t2muGxRVx0g_QPrelO?usp=sharing
Regards
Hi, @Werick
Maybe you can try the following methods.
Measure:
%Availability =
VAR _BASELINE_VALUE =
CALCULATE (SUM ( Incidents[Total Business Minutes for the Day] ),
FILTER (ALL ( Incidents ),
[priority] = MAX ( Incidents[priority] )
&& [supporting_service] = MAX ( Incidents[supporting_service] )))
VAR _VALUE_TO_COMPARE =
CALCULATE (SUM ( Incidents[Business Minutes impacted] ),
FILTER (ALL ( Incidents ),
[priority] = MAX ( Incidents[priority] )
&& [supporting_service] = MAX ( Incidents[supporting_service] )))
VAR _Avail = DIVIDE ( _BASELINE_VALUE - _VALUE_TO_COMPARE, _BASELINE_VALUE )
RETURN
IF ( ISBLANK ( _Avail ), 1, _Avail )
If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
This does not solve the issue.
The measure now only supports "slicing" the data for priority and not anything else.
I want to be able to change the priority columns to lets say Site or maybe FY-Month.
So i need a "generic" availability.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |