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
)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

tamerj1 
I've implemented this measure and is currently showing all rows as 1. I also have a date slicer on the page (which i might need at a later stage ) and it looks like this ignores the date slicer and looks at the whole dataset.

The initial measure i had below works but need it to also include slicer for Item_warehouse_location:

 

 

Rank =
RANKX (
    FILTER (
        Sales,
        EARLIER ( Sales[Sales_Transaction_ID] ) = Sales[Sales_Transaction_ID]
    ),
    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?