cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Re: RankX Measure Issue

Your question is not clear.  Please show the expected result here.

ggilmoreatu Regular Visitor
Regular Visitor

Re: RankX Measure Issue

@Ashish_Mathur

 

I would like to write a RANKX formula that ranks the TOP and BOTTOM 5 Country and Categories based off of IYA. So as different slicers are selected it will change the Top and Bottom 5.

 

For example "LA" is selected in the Region slicer then the TOP 5 will show the top 5 country/categories that have the top 5 IYA and bottom 5 IYA. As the timeframe slicer is changed as well the TOP  and Bottom 5 can change as well. Example LW Canada ^&8 could be in the top 5 but L52W it may not be. Below is a picture of how I invision is roughly looking but only 5 rows.

 

Rank.PNG

 

I know it will be a RANKX formula and I can then use the TOPN function on the filters... Thank you for all the help and I look forward to hearing from you

Super User
Super User

Re: RankX Measure Issue

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.

ggilmoreatu Regular Visitor
Regular Visitor

Re: RankX Measure Issue

@Ashish_Mathur

 

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.

Super User
Super User

Re: RankX Measure Issue

Hi,

 

I sorted but still did not see any numbers in the IYA column.  It was entirely blank.

ggilmoreatu Regular Visitor
Regular Visitor

Re: RankX Measure Issue

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.

Super User
Super User

Re: RankX Measure Issue

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.

ggilmoreatu Regular Visitor
Regular Visitor

Re: RankX Measure Issue

@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 slicer.PNG

 

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

 

 

Super User
Super User

Re: RankX Measure Issue

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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 197 members 2,124 guests
Please welcome our newest community members: