Ranking on fixed date sum

Question

Hi,&nbsp;I have made the following measure for ranking, depending on my TopN slicer it gives me a ranking of sales data by brand name, but always includes an "Other" sum.However this ranking is based on a choosen time frame and works just with one, but I would like to create a table with multiple time columns like Full year, YTD, Month etc.Is it possible to have this ranking formula to be fixed on for example the YTD time frame? And do I have to make a seperate YTD measure to include it in the formula?&nbsp;ranking = VAR ProductsToRank = [Waarde van TopN]VAR Ranking = rankx( allselected( 'Brand names'[Brand]), 'Sales Data'[Sales amount])VAR IsotherSelected = SELECTEDVALUE('Brand names'[Brand]) = "Others"VAR Result = IF(IsotherSelected, ProductsToRank +1, IF ( Ranking &lt;= ProductsToRank, Ranking, Ranking + 1) )Return&nbsp;Result

amitchandak · Answer

Anonymous , if you want to switch rank to topn refer 
&nbsp;
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM 
&nbsp;
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

anonymous · Answer

I'm not sure this works.I want to have a table with data on for example three measures: MAT, YTD and last Month. I want the ranking to always work on MAT, so even if I make a table with only data by month (12 months in the columns), still I want the ranking made by MAT.&nbsp;Is this possible?

Forum Discussion

Ranking on fixed date sum

2 Replies

Related content

Duplicate ranking

Between date filter with fixed start date and latest end date

Rank with conditions

Dynamic Ranking

Ranking KPI card