Rank and count

[ADP007]

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 attributionPathid (column PathCount).

Thanks

D.

[amitchandak]

@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]

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