Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Qty items counted accross multiple bins

Hello

 

I have 5950  items in a warehouse spread accross 9657 bins. At the moment the calculations show how many bins have been counted, how do I calculate how many items have been fully counted? 

So 1 item may have 20 bin locations but only 19 of those locations may have been counted therefore the item is not fully counted, but if another item has 20 bin locations and all of those locations have been counted then the item is fully counted. How do I show the qty of items which have all it's bins counted?

 

Thanks 

Bailey14

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Icey

     

    Unfortunately it's not worked, however I've created a seperate table for each warehouse using a pivot table to create the correct values.

    I really appreaciate your time trying to fix this though.

     

    Kind regards

     

    Bailey14

8 Replies

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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi

       

      Not sure if this would help? This particular item has several different locations but not all the locations have been counted, therefore the item is not fullt counted. See 'counted' column

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous ,

         

        Please check if this is what you want:

        Is Counted All Bins Measure =
VAR ItemBins_ =
    CALCULATE (
        COUNT ( 'Table'[Bin Code] ),
        ALLEXCEPT ( 'Table', 'Table'[Item No.] )
    )
VAR CountedItemBins_ =
    CALCULATE ( SUM ( 'Table'[counted] ), ALLEXCEPT ( 'Table', 'Table'[Item No.] ) )
RETURN
    IF ( ItemBins_ - CountedItemBins_ = 0, 1 )

        qty of items which have all it's bins counted Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Item No.] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        [Is Counted All Bins Measure] = 1
    )
)

         

         

        Best regards

        Icey

         

        If this post helps, then consider Accepting it as the solution to help other members find it faster.