Forum Discussion

adnyesh's avatar
adnyesh
Regular Visitor
9 years ago
Solved

Change Rank Dynamically by user selected Filter

I am using a RANKX function in which i am passing the following statement    Rank = RANKX(FILTER(ParentData,ParentData[Customer]="XYZ"),VALUE(ParentData[TurnAroundTime]),,ASC,Skip)   This is prov...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    adnyesh

     

    Try to add an index column and create a measure as below.

     

    RANK =
MINX (
    FILTER (
        SELECTCOLUMNS (
            ALLSELECTED ( ParentData ),
            "index", ParentData[Index],
            "rank", RANKX ( ALLSELECTED ( ParentData ), ParentData[Turn Around Time],, DESC, DENSE )
        ),
        [index] = MAX ( ParentData[Index] )
    ),
    [rank]
)

     

     

     

     

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

adnyesh

 

Try to add an index column and create a measure as below.

 

RANK =
MINX (
    FILTER (
        SELECTCOLUMNS (
            ALLSELECTED ( ParentData ),
            "index", ParentData[Index],
            "rank", RANKX ( ALLSELECTED ( ParentData ), ParentData[Turn Around Time],, DESC, DENSE )
        ),
        [index] = MAX ( ParentData[Index] )
    ),
    [rank]
)

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Eric_Zhang 

Hello, I am trying to solve nearly the same problem. Thanks for answer.
Why do we need index column any other unique column would do the trick? or is it need to be ordinal?

regards,