Forum Discussion

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

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