Forum Discussion
Power BI Ranking by different columns in different tables
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 wh...
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
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.