Forum Discussion

Ahmedismaeell's avatar
Ahmedismaeell
Regular Visitor
2 years ago
Solved

Exclude certain rows

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's avatar
    v-zhangti
    2 years ago

    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.

     

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    2 years ago

    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.