Help - Rank a dynamic column? I need the rank column for Lookup function.

Question

I have a date column. I created an index column which starts from 1.&nbsp;For example:Items&nbsp; Ranka&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;3d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;When I apply the filter- It shows:Item&nbsp;&nbsp; Rankb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;2c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;3&nbsp;But I need something like this -Item Rankb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;And I need to use that Rank column as a Lookup column to find other values.

az38 · Answer

Hi&nbsp;Anonymous&nbsp;try smth like thisMeasure = rankx(ALLSELECTED(Tbl_Rank);CALCULATE(FIRSTNONBLANK(Tbl_Rank[Items];Tbl_Rank[Items]));;ASC)

anonymous · Answer

Hi,Thanks for your reply!But the code did not help.I'm getting 1 for every row in the table.It does not sort the remaining rows on the basics of start dates after applying the filters.&nbsp;Thanks

az38 · Answer

Hi&nbsp;Anonymous&nbsp;It's strange because it works great with any filters appliedcould you show all youe data model or *.pbix?

anonymous · Answer

Thanks for your reply.&nbsp;How do we attach our pbix file here?&nbsp;&nbsp;

az38 · Answer

Anonymous&nbsp;try cloud storage like&nbsp;https://uploadfiles.io/

Forum Discussion

Help - Rank a dynamic column? I need the rank column for Lookup function.

10 Replies

Related content

Dynamic Column headers

Dynamic Column Name

Dynamic Variable in Calculated Columns

Dynamic column comparison of last column

User Defined Function - Dynamic Formatting