Forum Discussion
Dynamic RANKX with multiple filters and slicer
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 dataRanking Measure = RANKX ( ALLSELECTED ( Sales ), CALCULATE ( SUM ( Sales[Item_Price] ) ), , ASC, DENSE )
Anonymous
This dynatic behaviour cannot be achieved by a calculated column. Only measures can be that dynamic. Please check if this measure works and if yes we'll try to find a solution for the ranking slicer
Rank Measure =
CALCULATE (
RANKX ( Sales, SUM ( Sales[Item_Price] ),, ASC, DENSE ),
ALLEXCEPT ( Sales, Sales[Sales_Transaction_ID] ),
VALUES ( Sales[Item_Warehouse_Location] )
)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
)
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 dataRanking Measure = RANKX ( ALLSELECTED ( Sales ), CALCULATE ( SUM ( Sales[Item_Price] ) ), , ASC, DENSE )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?
