It wont work cause of indicrect relation, many to many . The file i attached has default reliationships with clean power query function
Table work across relationship as production no as id to retrieve Op name for "OperationNo"
After few modification of power query. The table cant display right now the data i m adding from Failregistrtation and MRPoperation