Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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