Dax measure to check countries

[Anonymous]

Hello everyone,

I've the following dataset:

Dim table Customer:

CustomerID	CustomerName
1	Harry
2	Henny
3	Bob

Fact table 1:

CustomerID	Product	Country
1	A	NLD
1	A	BEL
1	B	DEU
2	A	DEU
3	C	GRC
3	B	MLT

I'm trying to create a dax measure where i can check wheter a customer has a product in a specific country.

For example I want to check if customers have products in NLD or MLT.

My desired result would:

CustomerName	Measure
Harry	1
Henny	0
Bob	1

Thank you in advance!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Expected outcome measure: =
COUNTROWS (
    FILTER ( RELATEDTABLE ( 'Fact' ), 'Fact'[Country] IN { "NLD", "MLT" } )
) + 0