Forum Discussion
Rfranca
Resolver IV
Resolver IVRanking TOP N sales without zeros
I'm doing the sales rank, but when I set up the table for presentation the products that had sales with zero appear in the rank table, how do I mount the rank without the products with sales with ...
Hi Rfranca,
Try this measure in the Mx_sales table
=RANKX(FILTER(All('PRODUCT'[ProductName]),[Ttotal_Sales]>0),[Ttotal_Sales],,ASC,Skip)
In the Visual level filters, apply a criteria on the Ttoal_Sales of >0
Hope this helps.
RfrancaResolver IV
Resolver IV
Ashish_Mathur
Super User
Super UserYou are welcome.
siroopm2020Helper I
how to avoid zero values while ranking?
- Ashish_Mathur
Hi,
That is what my formula suggested on Jan 18, 2018 should do. If it is not working as expected, then share some data, describe the question and show the expected result.