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])

RobvB's avatar
RobvB
Frequent Visitor
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 ,

 

If you get the correct answer yourself, you can mark it as the correct answer.If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

 

Best Regards,
Henry


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