Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

INDEX function issue

Good afternoon, everyone!  I'm working on a school project and have a basic task, which turned out very difficult to solve. I have two tables: Sales table (top one) and Shops table used as mapping (...
Need Help
Show and Tell
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    1 year ago

    Please provide sample data that fully covers your issue, in a usable format (no screenshot).
    Please show the expected outcome based on the sample data you provided.

alena2k's avatar
alena2k
Icon for Resolver IV rankResolver IV
1 year ago

hi there! In addition to the order by direction you need to re-define the contest for SUM() using CALCULATE:

measure = INDEX(1, ALLSELECTED('Table'[store]),
                   ORDERBY(CALCULATE(SUM('Table'[sold]), REMOVEFILTERS('Table'[city])), DESC))
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    hi! thank you! unfortunately, that didn't really help 😞 
    here is what i got using your solution, looks same to me. what can be the source of the problem?

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      Please provide sample data that fully covers your issue, in a usable format (no screenshot).
      Please show the expected outcome based on the sample data you provided.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Anonymous,

         

        As suggested bu super user can you please provide sample data that covers your issue with expected output, it will be helpful for us to address your issue more effectively.

         

        Regards,
        Vinay Pabbu