Possible to add a measure as a row and not value

[swwong1]

Hi All

Just wondering if it's possible to add the result of a measure into the 'rows' area. The below result is what I would like but I can't get the highlighted column to display like this as I have another dimension in the columns area. Plese see attached PBI file.

https://www.dropbox.com/s/v9ljinv2r0p7w2v/Weekly%20Info.pbix?dl=0 

Many thanks!

[swwong1]

@Shahfaisal 

Many thanks, I have used SUMMARIZECOLUMNS to create a new table

[Shahfaisal · Accepted solution]

That is how a measure works in PivotTable. I would:

1. Create a sperate table that has SalesPerson and their ClientCount. You can do this in a database if you have access to, or in Power Query.

2. Join that table with the existing table on SalesPerson. 

3. Use the client count column from the new table in your PivotTable (in the rows area) and it should work the way you are expecting.