How do I produce this table from this input data?

[pmcinnis]

I need to produce the table 'Desired Output' from the data in the tables 'Results' and 'Guidelines'.

• 'Results' is a table of chemical concentration results.
  • 'Factory' is the factory where the chemical was sampled.
  • 'result type' is the type of sample.
• 'Guidelines' is a table of health guidelines for the various chemicals. Chemical concentration results should be below the guidelines to ensure public safety.
• The table 'Desired Output' presents the number of results above guideline for each chemical at each factory, for result types K and L but not result type J.
• Many chemicals don't have guidelines, so ignore those chemicals. Leave them out of the table 'Desired Output'
• Where the number of results above guideline for a given chemical at a given factory (for result types K and L) is zero, make the entry in 'Desired Output' a blank rather than zero
• Where a chemical has no results above guideline at any factory (for result types K and L), leave that chemical out of the table 'Desired Output'. In the example below, chemicals c and d are left out of 'Desired Output' for this reason.

I've attached a photo of the tables below. I haven't found a way to attach or include data tables to my posts, and I've tried several different ways suggested by experts here but none has worked. I don't think Dropbox is an option for me. OneDrive might be though I would need advice on how to create the link.

[HotChilli]

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... 

[pmcinnis]

I'm familiar with this article, and have tried the solution described in it before (#2) but can't get it to work. I tried it again just now, but still no luck. Can't get it to work at all.