Dynamic Ranking

[AishwaryaS]

Hi,  I have the below scenario where I want to calculate rank of the materials based on the Date, ID and Item in ascending order.

And Each time a slicer filter is selected, the rank must change dynamically within the selection. 

Before Filter :

Material	ID	Item	Date	Quantity	Rank
Mobile	103	1	01/01/2021	2	1
Mobile	103	2	01/01/2021	16	2
Mobile	104	6	05/01/2021	8	3
TV	100	1	01/01/2021	10	1
TV	101	3	12/01/2021	5	2
TV	102	6	16/01/2021	15	3

After Date Selection between 10/01/2021 to 20/01/2021 :

Material	ID	Item	Date	Quantity	Rank
TV	101	3	12/01/2021	5	1
TV	102	6	16/01/2021	15	2

Any help would be appreciated. Thanks in advance.

[amitchandak · Accepted solution]

@AishwaryaS , Try a measure like

calculate(Count(Table[Quantity]), filter(allselected(Table), Table[Material] = max(Table[Material]) && Table[Date] <= max(Table[Date])))