Rank on multiple measures

[Anonymous]

I have the following scenario - able to handle in power BI with filters, but need to build a paginated report and can't use measure as a filter. 

I have 5 stores and a value1 and value2 - I want to rank the second value, but only for the stores which rank in the top three for the first value. 

so stores D and E are not ranked on value 2, as they are not in the top 3 for rank 1. 

Any suggestions? 

Store	Value1	Rank1	Value2	Rank2
A	100	1	50	3
B	200	2	75	2
C	300	3	100	1
D	400	4	20	NA
E	500	5	500	NA

[Anonymous]

Is this a static or dynamic ranking? In other words, do you put the ranks in a dimension/fact table or you want to be able to place the data in a visual and then adjust the ranks as you slice and dice?

Best
D.