I have a measure that is simply the variation of sales YTD.
varYTD = DIVIDE([SalesYTD 2017],[SalesYTD 2016])-1)
And a report in Power BI where on rows I have the stores and on columns I have: Sales 2016, Sales 2017 & varYTD.
How can I show only the top 10 stores based on the biggest varYTD (not based on the biggest sales)?
Solved! Go to Solution.