Forum Discussion

Rfranca's avatar
Rfranca
Resolver IV
8 years ago

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

 

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

 

Thanks for help!

Need Help

3 Replies

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    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's avatar
      Rfranca
      Resolver IV
      8 years ago

      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.

  • ccakjcrx's avatar
    ccakjcrx
    Resolver I
    8 years ago

    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.