UpTime/DownTime Calculation By Ignoring With Overlapping Time

[Anonymous]

 This is my source date .

And this is my expected out put. 


I have machine downtime(Start) and Uptime(End) dates. I want to calculate my uptime and downtime as shown in the below image. Here the concept is we have to ignore the Overlap timeintervals.

Here is the Sample .pbix https://drive.google.com/file/d/19XcxqyJcBxQy1mZSop4_cF1iEEGm61pJ/view?usp=sharing 

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

I updated your sample pbix file(see attachment), please check whether that is what you want.

Best Regards

[Anonymous]

@v-yiruan-msft  Thanks for your time. But it's not working as per expectation. 

1. When we select the slicer it should work as per selection.
2. If none selected then it should return overall Downtime which is not more than 24 hours per day. 

[Syndicate_Admin]

@Syndicate_AdminFirst of all thanks for your time.

This is working fine when I slice the data by type 0 but this is not working for type 1 (showing more than 24 hrs per day which is not expected). My main object is to calculate the down time per day which should ignore's the overlapping time.
For example in the below example on 8/26/2020 two machines involved in the Downtime. My expected out put is 23.4 hrs(showing 42.5 because not ignoring the value 19.0) when we don't have any slicer selection but when we select something it has to show the corresponding value for that day (type 0, 23.4 hr's and type 1, 19.0 hr's).

Is there any way to make it measure instead of column so we can make this calculation more dynamic in order to consider the slicers.?

[Syndicate_Admin]

@amitchandak @parry2k Is there any way to get the solution for this.?