Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Ranking Issues with Measures

  I would like to create a Top 5 and Bottom 5 ranking based off of a Measure that is interactive based off of the filter selections.   A picture is posted below(Dummy Data).. That I will further e...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Ashish_Mathur

 

I will re-post the link to download the file but I downloaded it from the file from the original link and made a selection on the time frame slicer and it worked fine... If you could download the orignial file again and make a selection on this slicer

 

Once this selction is made it will populate the table in the bottom left... I've verified this several times...

 

Here is the new link: https://drive.google.com/file/d/1Yqix6czPTLJ981_TRB8VmxnvZLi07ftW/view

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

This measure will rank all glb_category within a market

 

= RANKX(ALLSELECTED(POS[glb_category]),[IYA])

 

If you wish to rank the market, then remove the glb_category from the visual and write this measure

 

= RANKX(ALLSELECTED(geo[market]),[IYA])

 

You may now filter this measure by Top 5/Bottom 5.