Multivalue Bridge, Generating too many details, but the math works|Power Pivot|Excel Forum|My Online Training Hub

Good Morning, I have a table with multiple tickets, and these tickets have several columns with multiple values stored in them.  I broke them, and created a multi-value bridge table that contains them, and the tickets are in a separate table which is the one side of the relationship. I spend a lot of time, removing duplicates, or going back to the source table to isolate what I am seeing for verification.

I found this blog

And it worked for searching the multi-value field.  BUT when I try to filter by other columns within the lookup table, it doesn't total right.  

Blue is the fact table (Tickets), Orange is the lookup table (Country), Green is a Pivot table.  I most often display the data by the groups, and it's not totaling right.

My current measure:

CountryResult = COUNTX (
FILTER (
Tickets,
[Country] = FIRSTNONBLANK(Country[Code], 0 )
|| FIND (FIRSTNONBLANK(Country[Code], 0 ), [Country], 1, -1 ) > -1

),
[Ticket Number]
)

Finally, the real reason I'm doing this, is that I am not getting a filtered list of details when moving from Tickets, across Multi-Value Bridge to the lookup tables.  I tried: Chris Webb's BI Blog_ Making Power BI Drillthrough Return The “Right” Rows When You Use It With Complex Measures Chris Webb's BI Blog.html, and I remember it was said that it would in BI or PowerPivot, but I was not able to apply it to Excel 2016.

I have a learned a tremendous amount from your site, and videos, I know that I don't completely understand the structure of DAX.

Jonathan