Forum Discussion
adnyesh
9 years agoRegular Visitor
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...
- 9 years ago
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
6 years agoNot applicable
is it possible to create a slicer for this measure. For example to choose the Top 10?