Forum Discussion

felipecollazos's avatar
felipecollazos
Frequent Visitor
3 years ago

PROBLEMS WITH COUNTING CODES

Hi guys!

 

Im going to present you the next table

 

On this table we have:

Code: the code of our brand

Ranking: the ranking of this code

Fam ranking: the family ranking of this code

Picking qty: quantity ordered by picking orders (24h of shipping) - paying shipping cost for 24h shipping - normally 1 to 5 codes MAX

Replacement qty: quantity ordered by replacement orders (+48Hh of shipping) - no shipping cost, more than 10 codes (to fullfill warehouses)

 

So, what I want to do?

Count the number of codes (in top 300) ordered by picking orders... as we can see on the table. But I want this number (128) showing also on the number tab under the table. How can I make it? I cant add it a filter or anything else 😞

 

Thanks in advance

Need Help
Show and Tell
Tutorial Requests

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    felipecollazos , Try a measure like assuming you have a measure Count top 300 Pic

    Sumx(filter(Values(Table[Code]), [Count top 300 Pick])

     

    or share the calculation of Count top 300 Pick


    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • felipecollazos's avatar
      felipecollazos
      Frequent Visitor
      3 years ago

      There is no calculation for TOP 300, is another source of data. Each X time we change the TOPs.