Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Using RankX in DAX For PowerPivot / PowerBI

A common reporting need is to rank a certain Attribute by a value.  In DAX, the syntax is the following: RANKX(<table>, <expression>[, <value>[, <order>[, <ties>]]])   As always, you can also r...
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi 

 

What needs to be done if we want to find the Rank based on 4 columns like the way we can do in SQL using Row_Number (By Partition) eg. Row_NUMBER() OVER ( Partition By SurrogateID , MeasureID, NetAggPartID ORDER BY TINAgg ASC) 

 

Thanks