Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
When attempting to create a sales report to view revenue by country I can only revenue. I select country first and then revenue but it will only show the data for revenue.
Well looks like that was my problem. I created a DAX query to create the ZipCountry column in both tables and it looks like I had extra spaces in one of the queries and not in the other. Thank you for your help!
Hi @jaytrice26 ,
Have you solved your problem? If solved please mark the reply in this post which you think is helpful as a solution to help more others facing the same problem to find a solution quickly, thank you very much!
Best Regards,
Dino Tao
Do you have a relationship set up between your Sales and Geography tables?
Yes I do. they are connected via ZipCountry.
And are you certain the values of ZipCountry in Sales have exact matches in Geography?
User | Count |
---|---|
84 | |
69 | |
69 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |