TOP N sales without zeros

[Rfranca]

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 zero.

xRanking_Bt = rankx(ALL(dm_PRODUTO[NOME_PRODUTO]);[Mx_TotalValor];;ASC;Dense)

Thanks for help!

[ccakjcrx]

Hey @Rfranca!

@Interkoubessis on the right track. However, if you want to filter it out within the DAX expression, you'll need to post whether or not product sales information is in the same table as products. 

At that point, posting a link to your .pbix file would be helpful.

[Interkoubess]

Hi @Rfranca,

What about changing the filter condtion for the view (Matrix for example) and put the conditions different to zero.

Then you get the rank without the zero....

Let us know if it does not work....

Ninter

[Rfranca]

hi, @Interkoubess @ccakjcrx

If you use the view filter to not display the zeros, the ranking skips lines with zeros and displays something with 1,2,3,6,7,8,9,10 (4 and 5 are zeros).

And this way the display is incorrect.

I wanted to filter in DAX where the result will be a correct ranking.

I already researched bastabte and still have not found the solution.