Forum Discussion

Helper I

3 years ago

How to get ranking

Hi Folks, Need help on the ranking formula . As per the need :- 1. We need to show ranking as per Product and price from higher to lower i.e higher value should be 1 and then goes on .... 2. We...

Need Help

Anonymous

Not applicable

3 years ago

For case 1 could you try this please?

Ranking = VAR healthcare_products = FILTER('Table', 'Table'[Product] = "Healthcare") RETURN RANKX(healthcare_products, healthcare_products[Sales], , DESC, Dense)

let me know if this gives desired result, if so I should be able to do case 2 🙂