Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts,
I am using Matrix Reports with employee count against country values. The values are repeating in all rows as shown below.
Solved! Go to Solution.
You are most likely missing a relationship in your data model. Is the userid field in a different table than CountryDesc? If so, you'll need to relate those two tables.
You are most likely missing a relationship in your data model. Is the userid field in a different table than CountryDesc? If so, you'll need to relate those two tables.
Hi @Anonymous ,
Please share your pbix. This mostly likely has to do with the relationship between tables.
If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you.
Please read this post to get your question answered more quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Nathaniel
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |