Usage Metrics - Country of origin by email

[benk3i]

Hi,

I am connected to the "Usage Metrics" dataset for a report, and I am trying to show which country each user comes from. In the dataset, there is a "Users[UserPrincipalName]" that contains the email adress. 

Since I cannot transform the data (supposedly because it is a connected dataset), my idea was to create a measure that says

• When looking at the table Users[UserPrincipalName], if a row contains ".es", then return the value "Spain". 
• Then create a long measure that includes all countries in my company. 
• Then I can show "Views from Spain: X"

I have tried various ways without success. 

Any ideas?