Forum Discussion

Robert4049's avatar
Robert4049
Frequent Visitor
5 years ago

RankX Weird Behavior With Filter

Okay talked about confused, I went ahead and removed blank arrive date times but the still show up when I filter and I can't figure this out. Any hints?     MedicalUnitFirstDue = VAR CurrentExpo...
Need Help
Robert4049's avatar
Robert4049
Frequent Visitor
5 years ago

Hey Kelly,

I rewrote the column as 

    IF (
        Apparatus[Arrival Date/Time] <> BLANK() 
        && Apparatus[Apparatus Type ID] IN EngineTypeID,
        IF (
            RANKX (
                FILTER (
                    Apparatus,
                    Apparatus[Run Number]
                        == CurrentExposureID && Apparatus[Apparatus Type ID] IN EngineTypeID
                ),
                Apparatus[Arrival Date/Time],
                Apparatus[Arrival Date/Time],
                ASC,
                Skip
            ) = 1,
            TRUE (),
            FALSE ()
        ),
        FALSE ()
    )


Unfortunately there's no good way to redact the confidential data. 

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi sevenhills ,

 

Without actual data,it would be a little tough to find a solution.

Try below expression:

measure =
IF (
    RANKX (
        FILTER (
            Apparatus,
            Apparatus[Run Number]
                == CurrentExposureID
                    && Apparatus[Apparatus Type ID]
                        IN EngineTypeID
                            && pparatus[Arrival Date/Time] <> BLANK ()
                            && Apparatus[Apparatus Type ID] IN EngineTypeID
        ),
        Apparatus[Arrival Date/Time],
        Apparatus[Arrival Date/Time],
        ASC,
        SKIP
    ) = 1,
    TRUE (),
    FALSE ()
)

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!