Rank on multiple measures

Anonymous — Thu, 15 Aug 2019 21:47:46 GMT

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

Re: Rank on multiple measures

Anonymous — Mon, 19 Aug 2019 08:46:37 GMT

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.

topic Rank on multiple measures in DAX Commands and Tips

Rank on multiple measures

Re: Rank on multiple measures