Forum Discussion

nleuck's avatar
nleuck
Post Patron
6 years ago

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...
Need Help
nleuck's avatar
nleuck
Post Patron
6 years ago

amitchandak 

 

Thanks for the response, but it still doesn't work.

amitchandak's avatar
amitchandak
Super User
6 years ago

What is the issue? Are getting the same rank. try one with All, in place of allselected and check if is giving expected results

  • nleuck's avatar
    nleuck
    Post Patron
    6 years ago

    amitchandak 

     

    I'm getting the same rank. I even tried ALL instead of ALLSELECTED and got the same results.

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      I tried a similar query on the Direct query on SQL server. and seem have worked

       

      • nleuck's avatar
        nleuck
        Post Patron
        6 years ago

        amitchandak 

         

        Below I have another example when trying to use RANKX. The left table works just fine, but as soon as I add description to the table it ranks everything as 1. I don't understand why.

         

        Formula: 

         
        Rank by Product = RANKX(ALL('table1'[product_id]), CALCULATE(SUM('table1'[available_value])),, DESC, Skip)