Forum Discussion
Grouping by User
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.
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/
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.
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.