Forum Discussion

RobvB's avatar
RobvB
Frequent Visitor
5 years ago
Solved

RANKX using a measure

I have a table with sales transactions. These are item level transactions, so multiple transactions per item/store/date/etc. First, I want a total per store, so I create this measure: total $ per ...
Need Help
  • RobvB's avatar
    RobvB
    5 years ago

    I got it to work. My problem was that I was using the transaction table as the 'main' table, but since I want ranking per store, I should use the store table.

     

    Rank Sales Per Store = rankx(ALL(ITK_Retail_AM_OMOperatingUnitEntity), ITK_Retail_AM_ITKRetailTransactionsView[Total Sales Per Store])

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi RobvB ,


According to your current description, you want to get the top 5 of $ per store. Try a simple method, use Top N in "Filters on this visual", refer to the following:
Put the field in By value.

 

Then, put the Store in the slicer and filter the top5 items corresponding to different stores.


If the problem is still not resolved, Please describe the exact requirements and point out detailed error messages. It is best to provide sample pbix file so that I can do the correct test, looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.