Exclude certain rows

[Ahmedismaeell]

Hello everyone,

I hope you can help me, i need to exlude the rows wich have status code U only if there is another row with same date, shift and lineguide and with status code A with earlier start time.

Any ideas ?

[v-zhangti · Accepted solution]

Hi, @Ahmedismaeell 

You can try the following methods.

TimeA = CALCULATE(MIN('Table'[StartTime]),FILTER(ALLEXCEPT('Table','Table'[ScheduleDate],'Table'[Shifts],'Table'[LineGuid]),[StatusCode]="A"))

TimeU = CALCULATE(MIN('Table'[StartTime]),FILTER(ALLEXCEPT('Table','Table'[ScheduleDate],'Table'[Shifts],'Table'[LineGuid]),[StatusCode]="U"))

Measure = IF([TimeA]<[TimeU]&&SELECTEDVALUE('Table'[StatusCode])="U",1,0)

Result:

Is this the result you expect? Please see the attached document.

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.