I want to rank staff bi dfferent measures, one of the measures are located in a seperate table - they are not related and I have no idea how to relate them - therefore im using another table that combines them.
(Hunters fact table) - related in KPI table and Orders table (below) linked with ID's.
One of my measures are by tasks - Measure = RANKX(ALL('KPI'[HunterRelated]);[KPI-Task+];;DESC;Dense)
However when i try to rank by sales in orders table and putting the measure into the table all the values return as one. In a seperate table the ranking are like they hsould be.
I think i know that the issue might be the RANKX(ALL(Orders[HunterRelated]); and RANKX(ALL('KPI'[HunterRelated]); because they are in different tables. Is there a way how i could combine them and show them in the same table or just for the overal ranking eg. And my fact table is related into otehr tables and it only filters by it.
And for overall rank i just want to add the ranks together. (rank the rankings) (table below would be overall rank) rank+rank