Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Dynamic BOM

Hello everybody,

 

I need your help again.

 

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

 

The solution should look like this:

 

 

Bom_Zielbild.png

The articels are structured in 2 different levels:

 

Production_Structure.png

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
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

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.

Anonymous
Not applicable

Hello @v-yuta-msft ,

 

thank your for your help, but unfortunately the measure doesn´t work.

 

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:

Model.PNG

 

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

 

Thank you for your support!

Christian

 

@Anonymous ,

 

Still not quite clear about your requirement. Could you share more details about your expected result?

 

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.

Anonymous
Not applicable

@v-yuta-msft,

 

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

 

Bom_Zielbild.pngI 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.

 

Thank your for your suppport!

cfeiburg

 

 

Anonymous
Not applicable

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.