Forum Discussion
Grouping by User
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
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.
7 Replies
Sorry, not sure your link came through or some thing, to which tutorial are you referring?
Can you post the formula for those 3 measures.
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?
The link with the tutorial is: https://www.simple-talk.com/sql/reporting-services/working-with-sql-server-data-in-power-bi-desktop/
