Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |