Extracting data between unrelated tables in power BI

[notintoexcel11]

Hi,
I am facing an issue with extracting data between 3 different tables. There is a bridge table that I have created to form one-to-many relationships between bridge table and each of the three tables. These tables did not have unique values or equal no. of row items so I was getting a prompt for many-to-many relation.
In 1 of the 3 tables, I have customer code, and 1 customer code may have multiple materials linked to it. 1 report gives details of the quantity of materials or different line items that needs to be dispatched and I need to map the details of actual dispatch against the same customer ID using another table. Then finally calculate the ratio of actual dispatched vs to be dispatched quantities.
Please see if there is a possibility to help me out with this!

Thank you!!   

[notintoexcel11]

I want to create a measure or calculation to capture the MTD (%) of the dispatch efficiency. Dispatch efficiency is the ratio of billing quantity to the pending quantity. I want to see the MTD value against each of the plant codes mentioned. Please guide me through.

My present calculated measure for MTD is giving me wrong data.
I do not have any master date table that is connected to the pending and billing data tables. Do I need to create that relationship as well? 

[Ashish_Mathur]

Hi,

8998/100036 is 8.9% and that is what you have in the green box.  So what is the problem?

[notintoexcel11]

As and when I select the plant code, you can see as in the figure below, I have selected bangalore code with division code as 30, but the data considered in billing is for division 20 for bangalore. How do I incorporate that in my MTD calculation

The code for MTD% currently being used =

[Ashish_Mathur]

Share the download link of the PBI file.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.