Forum Discussion
Dynamic Rank per Product in Time Period
Hi I need to be help create a Rank column. I need to be able to generate the rank in the context of the Time Period for the Products based on the Amount and This rank will be in the context of t...
Zubair_Muhammad
Community Champion
Community ChampionHi 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
)
Zubair_MuhammadCommunity Champion
Community Champion
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
- Zubair_Muhammad
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 )
