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]
)

 

 

 

 

jkenne01's avatar
jkenne01
Frequent Visitor
7 years ago

This is a great post and has helped me with my pattern I am trying to solve.

 

However the only difference is that I need to have the ranking value reset for each Customer.

 

So if I have both Customer ABC and XYZ selected then each would be ranked Individually not all together. The RANK Values would be 1, 2 and 1,2 for both customers.

 

Any ideas how I can do this. I have been searching now and over a day.

 

Thanks in advance.