Forum Discussion

kilala's avatar
kilala
Icon for Resolver I rankResolver I
8 months ago
Solved

Rank shows all 1

Hi all,   I have a trend bar chart that want to show "Exclude top 5". It will show all months that is ranked 5 and above based on total volume.  This is the DAX I used: Top 5 Vol (Trend) = RANK...
Need Help
Show and Tell
  • danextian's avatar
    danextian
    8 months ago

    Hi kilala 

    Is DIM_TIME_PERIOD_SELECTED[Month_Year] custom sorted by another column? If so, you need to include that in your ALLSELECTED statement as well.

MichaelVenables's avatar
MichaelVenables
Regular Visitor
8 months ago

Hi Kilala,
you might need to use the ALLSELECTED function in your measure to break the local filter context of the x axis if you try the measure below.

Top 5 Vol (Trend) =
RANKX(
ALLSELECTED('DIM_TIME_PERIOD_SELECTED'[Month_Year]),
[Volume Selected],
,
DESC,
Dense
)

Then when you select your bar chart. drag the new meausre into the filters on this visual section and set the filter to is greater than 5.

Hopefully this helps.

 

Michael