Comparing two tables without relationship using a venn diagram, measure not showing values

[Anonymous]

I'm trying to produce a venn diagram to show differences of what products a customer has uploaded to their systems. But my venn diagram is not working with the follwing measure.

Product file

MarketID	CountryID	ProductCode	LastUpdatedDate
2	16	5326401001	21/12/2017 00:00
2	16	5326401016	16/12/2016 00:00
2	16	5326401020	07/12/2021 00:00
2	16	5326401021	27/03/2019 00:00
2	16	5326401024	16/12/2016 00:00
2	16	5326401030	10/12/2021 00:00
2	16	5326401034	12/09/2018 00:00
2	16	5326401047	12/09/2018 00:00
2	16	5326401049	29/07/2020 00:00
2	16	5326401052	07/12/2021 00:00
2	16	5326401053	29/07/2020 00:00
2	16	5326401055	29/10/2021 00:00
2	16	5326401057	07/03/2019 00:00
2	16	5326401058	29/07/2020 00:00
2	16	5326401059	29/10/2021 00:00

 CustomerFile data

MarketID	CountryID	ProductCode	LastUpdated
2	16	5326401001	09/12/2021
2	16	5326401020	09/12/2021
2	16	5326401021	09/12/2021
2	16	5326401034	09/12/2021
2	16	5326401047	09/12/2021
2	16	5326401049	09/12/2021
2	16	5326401052	09/12/2021
2	16	5326401053	09/12/2021
2	16	5326401055	09/12/2021
2	16	5326401057	09/12/2021
2	16	5326401058	09/12/2021
2	16	5326401059	09/12/2021
2	16	5326401063	09/12/2021

Overlap = VAR Market = VALUES(ProductFile[MarketID])

VAR Country = VALUES(ProductFile[CountryID])

VAR Prod = VALUES(CustomerFile[ProductCode])

VAR Intersection = INTERSECT(Market,Country)

RETURN

COUNTROWS(Intersection)

Help appreciated

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

I seem to have some trouble understanding it. According to your test data, for the INTERSECT function returns a table that contains only the rows that are present in both table expressions as arguments. Thus causing the result returned by your formula to be empty.

A situation similar to the following is required:

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[lbendlin]

Overlap = COUNTROWS(INTERSECT(VALUES(CustomerFile[ProductCode]),VALUES('Product File'[ProductCode])))

[Anonymous]

Thank you can I add a slicer on this as I have different customers and these customers are in different countries, how can I do that would Ihave to have slicers for each product file and customer file?

[lbendlin]

Yes, the simple way is to have separate slicers.