You can upload the file to a cloud drive like OneDrive, GoogleDrive then share the link here or send me a message through Messages. Please mask the sensitive parts first.
@v-jiascu-msft https://drive.google.com/open?id=1pGmwarQb1xM9o0HeCj3T096vksUGuomO here is the link.
I couldnt, for some reason, make a realtionship from Geography. I had to export some data, as it is on a SSAS cube.
Please check out the demo in the attachment. There are solutions both of "calculated column" and "measure".
Though I don't know why there are duplicates in the Geography table which is thought to be a dimension table, the solutions work.
BTW, we can create a many-to-many relationship now.
I get an error trying to download this. But, I cannot make columns as I am on an SSAS cube.
Is it a Direct Query connection? I have updated the attachment. You can try it again.
View solution in original post
sorry for the late reply.
It is correct that I am using direct query. I will try to look at this tomorrow 🙂
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!