How Can I Create a RANKX Measure Without Triggering a Crossjoin?

Hamzehn , if you need rank on date in this table this can be column not measure

rank = rankx(filter(Table, [related company id] = earlier( [related company id] )  && [Fund] =earlier(Fund) ), [Date],,desc, dense)

You can have measure rank on max date

example

rank = rankx(filter(Table, [related company id] = max( [related company id] ) ), calculate(max([Date])),,desc, dense)

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

Hi Hamzehn 

Is this the result you want ? Group by Related Company ID and Fund , rank by Date .

You can create a column to return rank .

rank = rankx(filter(Transactions, [related company id] = earlier( [related company id] ) && [Fund] =earlier(Transactions[Fund]) ), [Date],,ASC, dense)

I have attached my pbix file ,you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.