Forum Discussion

LUCASM's avatar
LUCASM
Helper IV
7 years ago

Bottom 5

I am trying to build a Matrix table that shows the bottom 5 SKU's sold last month. I have seen this link https://community.powerbi.com/t5/Desktop/Bottom-N-without-blanks-and-zeros/m-p/545670#M256467...
Need Help
LUCASM's avatar
LUCASM
Helper IV
7 years ago

Hi MFelix

 

Quite sure my total dataset contains 53 different SKUs

11 had zero sales

the rest have sales between 22 Euro and 4 million euro

 

An example pibx file here.

 

Martin

MFelix's avatar
MFelix
Super User
7 years ago

Hi LUCASM ,

 

Not really sure what is happening because if you place the sales filter on the report level the bottom 5 works as expected however on visual level it's not working properly.

 

One way to overcome this is to create the following measure to use on your bottom 5 (place it on the bar code TOPN instead of sales)

Sales Positive = CALCULATE(SUM(Sheet1[Sales]); Sheet1[Sales] > 0)

I will put a question on the errors forum.

 

Regards,

MFelix

Hope this helps

  • LUCASM's avatar
    LUCASM
    Helper IV
    7 years ago

    Hi MFelix 

     

    Thanks for your help.

    I tried your approach, but that does not work for me either.....

    I shall have to wait and see if anything happens from your question on the errors forum.

     

    Kind Regards

     

    Martin