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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |