Exclude certain rows

Ahmedismaeell — Wed, 13 Dec 2023 11:10:51 GMT

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 ?

Re: Exclude certain rows

v-zhangti — Fri, 15 Dec 2023 06:43:25 GMT

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.

topic Exclude certain rows in DAX Commands and Tips

Exclude certain rows

Re: Exclude certain rows