Forum Discussion
Ranking Issues with Measures
Hi,
I cannot help you because there are no figures appearing in the IYA column in your visual. So even if i write a formula, i will not see any meaningful ranking result.
The way the formulas are set up is that some of the slicers need to be selected for the tables to display figures... Some categories may not have sales in certain markets so you will need to sort by IYA or POS to bring the numbers to the top of the table. Please let me know if you need anything else. I appreciate all of the help.
Hi,
I sorted but still did not see any numbers in the IYA column. It was entirely blank.
Just select a timeframe in the "perd_short_desc" slicer and it will populate the bottom tables... If I need to resend the file please let me know.
Hi,
Still no luck. I made a selection in the slicer but still did not see any numbers in the IYA column of the Table.
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
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.