Forum Discussion
Solved
create rank column based on column using dax
Greetings !! I have a region slicer which drop downs as Test1, Test2 , Test3. And a Rank slicer which has ranges and occurs based on the Rank column. i have data set given below . Region ...
You can create the column like this:
Column = VAR CurVal = [Text Value] RETURN CALCULATE( RANKX( Data, [Text Value], CurVal, ASC, Dense ), ALLEXCEPT( Data, Data[Region] ) )
LivioLanzo
Solution Sage
Solution SageYou can create the column like this:
Column =
VAR CurVal = [Text Value]
RETURN
CALCULATE(
RANKX( Data, [Text Value], CurVal, ASC, Dense ),
ALLEXCEPT( Data, Data[Region] )
)
You - from 4 years ago I guess - saved me a ton of time. I was trying to do a filter and trying to do something with the transform data - I needed to find the top 5 values for each hour and this plus a filter of >=5 on my new column was what I needed - thanks!