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

Anonymous — Tue, 04 Jul 2023 09:55:25 GMT

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

topic Measure/Dax help on Filter to a material number and then have it shows the BOMs in DAX Commands and Tips

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