Duplicate Rows

[Anonymous]

Hello Experts,

I am using Matrix Reports with employee count against country values. The values are repeating in all rows as shown below.

[AUaero · Accepted 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.  

[Nathaniel_C]

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