topic Re: Filter/Remove duplicates based on table criterias in DAX Commands and Tips

Filter/Remove duplicates based on table criterias

je_s — Thu, 15 Sep 2022 07:20:30 GMT

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

Re: Filter/Remove duplicates based on table criterias

Anonymous — Thu, 15 Sep 2022 07:32:24 GMT

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"?

Re: Filter/Remove duplicates based on table criterias

je_s — Thu, 15 Sep 2022 07:46:24 GMT

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?

Re: Filter/Remove duplicates based on table criterias

Anonymous — Thu, 15 Sep 2022 07:51:46 GMT

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:

Re: Filter/Remove duplicates based on table criterias

je_s — Wed, 21 Sep 2022 09:39:40 GMT

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.