Dynamic Ranking based on Filter Select

[Shoicest]

I am trying creating a dynamic Earning rank column for different   project_no   based on different filter selections (investor, region, city, industry, income_date, also the project_no itself), so that I can update rank of rows based on the selection.

I tried different solutions in the community, however, they don't work. All rows in my "Rank" column are 1. 

How can I fullfill that?

Here is my table, which name is "Full". And the rank should measure sum of Earning.

Thank you very much!

[Ashish_Mathur]

Hi,

Try this approach.  Ensure that the project_date column has the data type of Date (I see the entries are left aligned so they are probably text entries).  Create a Calendar Table with a relationship (Many to One and Single) from the Date column of the Data Table to the Date column of the Calendar Table.  To your visual, drag Project no and Date (from the Calendar Table).  Write these measures

E = sum(Data[Earnings])

Rank of E = Rankx(allselected(Calendar[Date]),[E])

Hope this helps. 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523