Forum Discussion
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 ...
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])
