Forum Discussion
Dynamic Rank per Product in Time Period
yes I can see that but It does not work when I do it but let me try again. I also have another requirement where I need to be able to display the Rank for each time period side by side and I tried to do that by filterting the data for the specific time period but it did not work. Any help is appreciated.
Basically I need to show a side by side comparison of the Product Rank over time period in a specific market
Hi rampsaladi
to show a side by side comparison of the Product Rank over time period in a specific market.....
You can try using this rank MEASURE
RANK_ =
RANKX (
ALLSELECTED ( Table1[Product] ),
CALCULATE ( SUM ( Table1[Amt] ) ),
,
DESC,
DENSE
)
Use a Matrix Table...Put Time Period in Columns..Products in Rows and RANK measure in values
This is really helpful you know I never thought of it, but I have one more request can I actually have a different rank measure for each Time Period, the only reason i ask it I have other measure values that I need to dsiplay along with Rank and if I add them its get little bit skewed. the look. So Ideally I would like to have a Rank Measure for Say latest 13 Weeks timeperiod data and this will change based on the Market Slicer
Hi rampsaladi
In that case try his pattern
RANK_Last 13 Week = RANKX ( ALLSELECTED ( Table1[Product] ), CALCULATE ( SUM ( Table1[Amt] ), Table1[Time Period] = "Last 13 Week" ), , DESC, DENSE )