Count of Customers based on count of their orders

[praveenpearl]

Hi, 

I've a Product field( I have 12 products in it) and a Cus no field. I need to build a visual like, no of customers ordered just one product out of those 12 products and no.of customers ordered just two products out of those 12.etc.,

Please help me with this.

[Greg_Deckler · Accepted solution]

Given an Enter Data query like this:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("PcaxDQAgCATAXagtRFB0FsL+a/j5guKSyxSVATVSVs96ji1u9w5mXGDOXWxzDzucTjSk6gM=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ProductNo = _t, CustomerNo = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ProductNo", Int64.Type}, {"CustomerNo", Int64.Type}})
in
    #"Changed Type"

You could create a table visual where you have an unsummarized CustomerNo and a distinct count of ProductNo and you could filter that to the specific count you are looking for.