Forum Discussion

ADP007's avatar
ADP007
Helper IV
2 years ago

Rank and count

Hi all,   How can I achieve the following? I would like to calculate the position of a row based on attributionPathid and timestamp (column Position) and the total number of rows for attributionPa...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

ADP007 , Try the new Rank Function

Rank(dense, allselected(Table[attributionPathid], Table[timestamp]),ORDERBY(Table[timestamp],DESC))

 

Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo

ADP007's avatar
ADP007
Helper IV
2 years ago

Thanks amitchandak 

 

Thanks for your reply.

Your solution works when I filter on an attributionpathID bu doesn't work when there are no filters

Without filter

 

With filter

 

 

 

Thanks

David