Forum Discussion
Rank by measure in Direct Query
Hello All, I'm trying to rank Branch Locations by a measure that finds the % of products with no sales to total inventory. When I try to create the rank measure in the visual all the locations ar...
I assume it is only copy-paste mistake and the actual formula is
RANKX(ALLSELECTED(table1[Branch Location]), CALCULATE(DIVIDE(SUM(table2[no sales value]), SUM(table1[total inventory value]))),,DESC,Skip)
There were issues with (.
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
What is the issue? Are getting the same rank. try one with All, in place of allselected and check if is giving expected results
I'm getting the same rank. I even tried ALL instead of ALLSELECTED and got the same results.
