Dax - Measure calculation for country visit count

[Anonymous_mdky]

Hi,

Could you please help me with the measure calculation for the below scenario,

I have a table like shown below which has the 'Name' and the number of times each person has visited a country:

	Number of visits
Name	China	US	UK	Germany
Roy	3	0	0	0
Joe	2	0	3	0
Marie	1	5	0	1
Vish	0	1	1	1
Wayne	5	0	0	0

I need to find the number of people who only visited China and not other countries.

In this case, it has to be '2' because only Roy and Wayne have visited China but not other countries.

Any help on this is appreciated.

Thanks a lot.

[Anonymous_mdky]

Its actually an output from a excel pivot that was shared in a normal excel which i am using as a source.

[tamerj1]

@Anonymous_mdky 
You may keep it pivotted if you have samll number of columns which I doubt with your real data. In case of large number of columns it is advised to unpivote the table using power query. That would also keep the door open for dynamic solution without having to add a new disconnected table. Three possible solutions as follows:

[ThxAlot]

visit.pbix

[tamerj1]

Hi @Anonymous_mdky 

is this s source table or a matrix visual?