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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Lyevon1
Frequent Visitor

Measure/Dax help on Filter to a material number and then have it shows the BOMs

Hi Sir/Mdm, would like to seek guidance on creating this measure/dax

I have 2 different set of tables, one is the material master data (table 1), and the other is the list of Combo Master with its Bill of materials (table 2)

Currently what i'm looking at is when user enters the material number, and if the item is found to be in the list of combo (table 2); the matrix table 1 will display all the bills of materials and the combo header. then if its a combo, it will display all the BOMs
 
enclosed is the screenshot example.

 

What i've done was creating a relationship between the Table 2 - BOM and Material Master Table 1 - SKUs, but the issue is the display in matrix 2 only display one of the BOM (if the user enters the component in the search) and unable to display the rest of the BOMs. Any idea how should i go around with this? 

 

And if the user enters an item code that has no combo, both matrix table will just remain as blank


Combo display BOMs.PNG



0 REPLIES 0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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