DAX measure - count of unique values

[hpayne93]

Hi,

I need some help with a new measure please.

I need to calculate the number of countries 'Contact' [address1:country} my [event participants] are from. 

Thanks

[amitchandak]

@hpayne93 , Not very clear

but a measure like below can help

distinctcount( 'Contact' [address1:country]) 

or

countrows(summarize('Contact', 'Contact' [address1:country]) )

or

countrows(summarize('Contact', 'Contact' [address1:country], 'Contact' [event participants]) )

or you can fact and dimensions in summarize