Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic RANKX with multiple filters and slicer

Hi,   Power BI newbie here.  I am trying to dynamically rank my dataset for each Sale Transaction based on the Item Price. However i also have a slicer filter for Item Warehouse location which...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Yes it is working but this is a calculated column which cannot interact with the filter context.
    Try this measure on the full set of data

    Ranking Measure = 
RANKX (
    ALLSELECTED ( Sales ),
    CALCULATE ( SUM ( Sales[Item_Price] ) ),
    ,
    ASC,
    DENSE
)

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 
Yes it is working but this is a calculated column which cannot interact with the filter context.
Try this measure on the full set of data

Ranking Measure = 
RANKX (
    ALLSELECTED ( Sales ),
    CALCULATE ( SUM ( Sales[Item_Price] ) ),
    ,
    ASC,
    DENSE
)

leojhernandez's avatar
leojhernandez
Helper I
1 year ago

I'm trying to achieve this same concept with slicer, but instead of using a calculation, in this example is doing a sum of sales, I need to use the earliest date. How do I achieve this?