Number of rows set to filters

[Syndicate_Admin]

Hello, I would like you to help me to elaborate the following:

I want a column in this table chart that lists the results (rows that are obtained after applying month filters). Example: That if I select the month of September, the 6 projects appear listed from 1 to 6 (in the index column), if I change the month, that the rows from 1 to n appear.

[v-luwang-msft · Accepted solution]

hI @Syndicate_Admin ,

You need to use the Rankx function of DAX. click here to see a detailed example.

Similar question refer: 

https://community.powerbi.com/t5/Desktop/Number-of-row-adjusted-to-filters/m-p/1684219 

And if quesiton still not solved ,pls provide sample data and expect output result.

Best Regards,
Lucien

[lbendlin]

You may want to specify what the order should be inside the month.  Is it alphabetically? by start date?  Is the order impactable by a filter choice or can it be a calculated column?