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:
![total_orders.png](/board/proxy.php?image=https%3A%2F%2Fclearify.com%2FAssets%2Fimages%2Ftotal_orders.png&hash=8f67ce7254147984fc154304cc53c7bb)
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.