Grouping by User

[michellefs_br]

I'm using this tutorial with SQL 2014 and AdventureWorks Database

I did exactly as it says on the tutorial, but when trying to create the chart, I click the Full Name and it shows a list of names and when I click on the 3 measures, sum, avg and count, it sums everything instead of showing it per person.

It should look like the first image, but it's showing as the second one

[MattAllington]

Have you joined the sales table to the customer table using the customer ID, and then placed the customer name from the customer table into your matrix on the rows?

[michellefs_br]

The link with the tutorial is: https://www.simple-talk.com/sql/reporting-services/working-with-sql-server-data-in-power-bi-desktop/

[michellefs_br]

[MattAllington]

So are you wanting to see sales rep names in your visualisations?  I can't tell from the image of the model if the sales rep table is correctly joined to the sales table. I suggest putting salesrep[fullname] on rows and then sales[territory id] beneath it on rows. If the first level is blank but you see all the data at the second level, then your columns are not matching for some reason. Maybe it is the wrong column. 

[michellefs_br · Accepted solution]

I figured what the problem was, on SalesPersonID, the column had only null values, I was meant to exclude them, but instead I selected all NULLs, so that's why the relationship wasn't working, I have excluded the NULLs and left all others and it's now working as it should.

Thank you all for your time in helping me out on this.

[kazlik]

Can you post the formula for those 3 measures.

[Greg_Deckler]

Sorry, not sure your link came through or some thing, to which tutorial are you referring?