I would like to create a pie graph that shows the frequency of the number of times a customer has bought, e.g. how many bought 1 time, how many bought 2 times, etc.
The raw information looks like this:
The total orders is a calculated measure:
Customer Total Orders = CALCULATE(DISTINCTCOUNT('Document Attributes'[Document Transaction Number]),'Document Attributes'[Document Type] = "Invoice"||'Document Attributes'[Document Type] = "Sales Receipt")
Customer names come from a related dimension
It would seem that the calculated measure needs some sort of legend to exist in the pie chart (because it only shows the total number), but I am at a loss here.
The raw information looks like this:
The total orders is a calculated measure:
Customer Total Orders = CALCULATE(DISTINCTCOUNT('Document Attributes'[Document Transaction Number]),'Document Attributes'[Document Type] = "Invoice"||'Document Attributes'[Document Type] = "Sales Receipt")
Customer names come from a related dimension
It would seem that the calculated measure needs some sort of legend to exist in the pie chart (because it only shows the total number), but I am at a loss here.