Forum Discussion

Emmy88_'s avatar
Emmy88_
Advocate I
1 year ago

Create buckets based on exact recipe values

Hi all,

 

I am looking for buckets based on exact same ingredient & volumes. Underneath example data.

 

You see 2 products: 28682 & 29274. 

 

28682 has 2 productions -> 100584919  & 100585055, both of them with exact same ingredients and exact same ingredient volume. If this is the case i would like to create 1 bucket for the 2 productions.

 

29274 has 3 productions, all with different volume & ingredient, so these orders should not be in buckets but separate.

 

 

How will i be able to structure this?

 

Thank you!

 

Emmy

 

 

 

Need Help

3 Replies

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    1 year ago

    Create a Calculated Column:

    UniqueID = 
    TableName[Ingredient] & 
    "-" & 
    FORMAT(TableName[Volume], "General Number")

    Create a new table:

    ProductionGroups = 
    ADDCOLUMNS(
    SUMMARIZE(
    TableName,
    TableName[Product],
    TableName[UniqueID]
    ),
    "ProductionCount", COUNTROWS(FILTER(TableName, TableName[UniqueID] = EARLIER(TableName[UniqueID])))
    )

    Create a measure:

    Bucket = 
    IF(
    MAX(ProductionGroups[ProductionCount]) > 1,
    "Bucket",
    "Separate"
    )

    Use a table or matrix visual to display your products.
    Add the Bucket measure to your visualization to see bucket assignments

     

    If this helped, a Kudos 👍 or Solution mark would be great! 🎉
    Cheers,
    Kedar
    Connect on LinkedIn

     

  • Emmy88_'s avatar
    Emmy88_
    Advocate I
    1 year ago

    Hi Kedar,

     

    Thank you for your help. I did follow the exact steps however i see bucket for all productions, whereas material 29274 should have separate. Do you know what is going wrong here?

     

     

     

     

     

     

     

    Gr,

     

    Emmy

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi  Emmy88_ ,

     

    Could you please clarify what you mean by 'create 1 bucket for the 2 productions'? Do you want to create a new column for bucket?

    If possible, could you also provide a sample of your data source or the pbix file?

     

    Best Regards,

    Bof