Power BI Ranking by different columns in different tables

[luiswellington]

Hello All, I would be very grateful if you help me with a challenge. I want to do a raking that takes into account four columns, however, three tables involved. Imagine that I want to have a table where the fields are (Emplyee_Name, Product_Category, Calendar year, Calendar month, [Total_Sales]]). In this table I want a Ranking by [Total_Sales] DESC. But, it needs to respect Date Filters on the page. I've been racking my brains over this for a week now and there is no material anywhere on the internet that teaches this. Can you help me with this, please ?

[amitchandak]

@luiswellington , Power BI Meausre rank (Rankx) work on based on column in visual

so in this case, you need, assuming total sales is a column

rankx(filter(allselected(Sales), calendar[Year], calendar[Month],employee[Emplyee_Name]) , calculate(Sum(Sales[Total Sales])) ,,desc,dense)

Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=25627s

New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo

[luiswellington]

Thanks for your attention @amitchandak , but, this formula doesn't work. The video shows columns in the same table and it is not my case.