Forum Discussion
Default Uptime Display Based on Outage Data
Hi cj0720 ,
I created a sample pbix file for you, please check whether that is what you want.
1. Create a date dimension table
2. Create a measure as below
Uptime % = var _workhours=8 //The normal working time of the day when the application does not malfunction var _downhours=CALCULATE(SUM('Table'[Downtime]),FILTER('Table','Table'[Date]=SELECTEDVALUE('Date'[Date]))) return if(ISBLANK(_downhours),1,DIVIDE(_workhours-_downhours,_workhours))3. Drag the date of Date table onto the column graph as X axis and Measure as Values field
If the above one is not applicable for your scenario, please provide some sample data in your model (exclude sensitive data)and your expected result with calculation logic. Thank you.
Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Hi cj0720 ,
I created a sample pbix file for you, please check whether that is what you want.
1. Create a date dimension table
2. Create a measure as below
Uptime % =
var _workhours=8 //The normal working time of the day when the application does not malfunction
var _downhours=CALCULATE(SUM('Table'[Downtime]),FILTER('Table','Table'[Date]=SELECTEDVALUE('Date'[Date])))
return if(ISBLANK(_downhours),1,DIVIDE(_workhours-_downhours,_workhours))
3. Drag the date of Date table onto the column graph as X axis and Measure as Values field
If the above one is not applicable for your scenario, please provide some sample data in your model (exclude sensitive data)and your expected result with calculation logic. Thank you.
Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Excellent and simple solution. Creating a separate table containing all dates is exactly what I needed to do. Thank you!