Filter/Remove duplicates based on table criterias

[je_s]

Hello

I need to keep track of production KPI's (stop time) based on the certain criterias mentioned below.

Example 1: Exclude all stops occuring during the same time as meeting, break or maintenance events. 

Example 2: Exclude TC-stops when occuring (and have the same duration) as a position stop

[je_s]

I'm not sure the Power Query-editor will do the trick in this case. Or do you have any suggestions? 

The thing is.. I want to remove all "Stopped"-events when they occurs simultaneously as a meeting/break or maintenance break and those are on diffrent rows with the same time stamp. 

[Anonymous]

My suggestion is you work on this using Power Query, as it will result a lot easier. However, should you want to pursue DAX, you can try creating a column and using an IF measure. It is not very clear what is it that differentiates the 2 examples, why is one "Actual stop" at [Position] = "TC_1" and the other at "Pos_2"? 

[je_s]

TC stands for Tact circuit if that makes sense. The tact circuit is always in status "stopped" when a position in status "stopped" but not the other way around. 

I've have tried using DAX and IF measures but have really got the results I was hoping for. Any suggestions?  

[Anonymous]

It might be a DAX hell to work on it by using IFs, CALCULATE, LOOKUP etc etc. My suggestion is that you use Power Query/M to deal with this. There's plenty of tools, try going on Add Column and Conditional Column: