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
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 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
    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
      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!