Division from 2 different tables and filtered

[rebrow31]

I have 2 tables, one containing information on how many good parts were produced, then I have another table which has data on parts that were rejected from a line. I have made this very simple visual: 

The good parts come from the production table, nd the reject parts come from the rejects table. There is a relationship between these 2 tables for Part no. It's worth mentioning, that the good part figures are filtered in the visual, the good parts are filteres according to which process they were going through (namingly the assembly process". So, this bar chart shows the good parts going in to the assembly line, compared to the reject parts (the rejects table only has data for parts rejected on the assembly line).

All I want to do is be able to calculate the % of rejects to the good parts (that have been filtered). So for example, on the first product on that graph, there are 465 parts and 11 were rejects, so I want to be able to calculate 2.36%. 

Does anyone know how I would go about this? Thanks.

[Anonymous · Accepted solution]

Hi @rebrow31 ,

You may simply try:

Measure = DIVIDE( COUNT('Reject Line Data'[WHICH LINE]) ,  SUM('Production'[IO]) )

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rebrow31]

Wow, it was that easy. Thank you so much, much appreciated! 

[Anonymous]

Hi @rebrow31 ,

I need more information about your tables and filters to help us clarify your scenario.

Could you please share me with your pbix file after removing sensitive data ?

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[rebrow31]

Hi, 

Removed all sensitive data, file is located: https://www.dropbox.com/s/fu1edi9vl1vlppo/Reject%20Line%20Dashboard%20-%20Copy.pbix?dl=0

Simply would like the reject parts as a % of the good parts (good parts have been filtered by machine)

[Whitewater100]

Hello:

I would suggest you make a dimension table containing all you unqiue part numbers and join both of these factual tables to the new "lookup" table. If you want to share a file representing this issue I'll take a look at it.  Joining the fact table is not a good practice. Hope this helps a bit. 

[rebrow31]

Hi, 

https://www.dropbox.com/s/fu1edi9vl1vlppo/Reject%20Line%20Dashboard%20-%20Copy.pbix?dl=0

sample pbix. Simply would like the reject parts as a % of the good parts (good parts have been filtered by amchine)