cancel
Showing results for
Did you mean:
Regular Visitor

## Dynamic BOM

Hello everybody,

I want to create a dynamic BOM based on sales articels.

The solution should look like this:

The articels are structured in 2 different levels:

On top is the articel that are sold, then the finished produced articel and on bottom the individual materials.

I want to choose the sales articel and then see which materials are used to produce them and the quantity.

I have three different tables: Calendar, Item table (unique entries) and Item Ledger Entry Tabel (contains all consumtpion and output for every article and materials).

Sorry for the short description of my problem. I am not sure if I should write more to explain my problem. If I explained something not clear enough or your missing information, please say something!

I am working on that for 4 days now and I don´t get close to the solution I need and I am thankfull for every hint or solution I can get!!

Thank you very much!

Christian

5 REPLIES 5
Regular Visitor

## Re: Dynamic BOM

Community Support Team

## Re: Dynamic BOM

You may modify BOM measure as pattern below:

```BOMListe =
CALCULATE (
SUM ( Tab_Item_Ledger_Entry[Quantity] ),
FILTER ( Tab_ITEM, Tab_ITEM[Verkauf] > 0 ),
FILTER (
Tab_Item_Ledger_Entry,
Tab_Item_Ledger_Entry[Document No] IN VALUES ( Tab_ITEM[No] )
&& Tab_Item_Ledger_Entry[Posting Date] IN VALUES ( Tab_Date[Date] )
)
)
```

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regular Visitor

## Re: Dynamic BOM

Hello @v-yuta-msft ,

Do you have another idea how to make it work?

The measure I tried to use:

```BOM = CALCULATE(
SUM(Tab_Item_Ledger_Entry[Quantity]);
FILTER(Tab_ITEM;Tab_ITEM[Sales Articles]="YES");
FILTER(Tab_Item_Ledger_Entry;       Tab_Item_Ledger_Entry[Document No] IN VALUES(Tab_Item_Ledger_Entry[Item No_])          && Tab_Item_Ledger_Entry[Posting Date] IN VALUES(Tab_Date[Date])))```

The data model I use:

Maybe you have another idea how to solve my problem. I am open to every solution!

Christian

Community Support Team

## Re: Dynamic BOM

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regular Visitor

## Re: Dynamic BOM

i want to create a structure which is based on the sales article.

I have a slicer to choose my sales article, e.g. Item: 1000.000 Red Car then I want to have a bill of material  in a table with all the production articles which are need to produce the Red Car. As you can see in the picture above.

The BOM is basd on the selection of the slicer. The values in the slicer are text type, not a number.

The Data model is the same as I posted in my first post.

I am so sorry for bad explanation, i hope could make my goal more clear.