Rank and count

Question

Hi all,&nbsp;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 attributionPathid (column PathCount).&nbsp;ThanksD.&nbsp;&nbsp;

amitchandak · Answer

ADP007 , Try the new Rank Function 
Rank(dense, allselected(Table[attributionPathid], Table[timestamp]),ORDERBY(Table[timestamp],DESC))
&nbsp;
Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo

adp007 · Answer

Thanks&nbsp;amitchandak&nbsp;&nbsp;Thanks for your reply.Your solution works when I filter on an attributionpathID bu doesn't work when there are no filtersWithout filter&nbsp;With filter&nbsp;&nbsp;&nbsp;ThanksDavid&nbsp;

Forum Discussion

Rank and count

2 Replies

Related content

Duplicate ranking

Ranking KPI card

Counting Ranks

Counting nulls

Rank with conditions