Forum Discussion

Robert4049's avatar
Robert4049
Frequent Visitor
4 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
v-kelly-msft's avatar
v-kelly-msft
Community Support
4 years ago

Hi  Robert4049 ,

 

Could you pls share your .pbix file for test?

Remember to remove the confidentail information.

 

Best Regards,
Kelly

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

Robert4049's avatar
Robert4049
Frequent Visitor
4 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
    4 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!