Rankx function

[richreay84]

hi all,

i'm pretty new to Power BI. I'm currently running data by product range and site / store. I'm trying to create a rank which will highlight to top x number of ranges sales for all sites. Then using this rank I want to create a summary of the site / store sales. I've used the basic rank functionality but when i filter for a selection of sites / stores the top ranges changes based on the selection of sites / stores and doesn't reflect the total top ranks etc.

thanks in advance

Rich

[v-piga-msft]

Hi @richreay84,

It seems that you have problem with fiter and rankx. 

To understand your sceanrio better, could you share some data sample and your desired output so that we could help further on it?

Best  Regagrds,

Cherry