Adding a Pivot Column based on Postcodes

[Mike282]

Hi

I've got a dataset with a column containing the postcode of each recorded user. I want to do a count of each unique postcode value so that I can map that to a map visualisation with the Count being the value field against the postcode. When I tried to use the Pivot Column function in query editor, it appears to just give me rows of 0s as opposed to an aggregate count score against each unique postcode.

[Anonymous]

I'd recommend doing this count using a measure and make use of the function DISTINCTCOUNT

https://msdn.microsoft.com/en-us/library/gg492142.aspx

[GilbertQ]

Hi there, you could create a measure in your data model after the data has loaded.

You can use the DISTINCTCOUNT on your Postcode Column. This will then count each PostCode only once.

DISTINCTCOUNT(ResellerSales_USD[SalesOrderNumber])