Forum Discussion
Sales Range and Ring Chart Error?
Hi there!
English is not my first language but I'll do my best.
I'm trying to make a ring chart dividing sales in 5 different ranges. In other words, dividing customer tickets by total amount in 5 categories. I manage the DAX formula (at least I think) but chart is not looking good.
Main problem could be that many tickets have 2 or more items on it and Filter Function makes it difficult. These sales are the sum of 2, 3, 4 differente items (SKU) so my "range" is not being counted as one final amount but 2, 3, 4 different ranges because each item has a different value.
Will add screenshots and hope they're self explanatory
Order Number in Sales Table
Sales Range Table
Ventas en Moneda = Total Sales Amount
'Ventas' = Sales Table
(Cantidad) * (Precio Neto Unitario) = Quantity times (*) Net Price per unit
'Rangos' = Ranges Table
Desde = From
Hasta = To
If you see, is working on table view but not as a Ring Chart
Would like to have it like this one
Thanks in advance for any help.
I did it.
Solution was to creat a new table with Order Only and filter that one.I'm new to all this so congrats to myself haha!
Feels like progresing.
4 Replies
I did it.
Solution was to creat a new table with Order Only and filter that one.I'm new to all this so congrats to myself haha!
Feels like progresing.what to you get when you remove document number from details?
Hi tamerj1!
Nothingtamerj1
I tryed this other DAX scenario where [tickets] is my distinct of sales
CALCULATE([Ventas en Moneda], -- a sumx of qty * net priceALL(VENTAS[Numero Documento]), -- Order Number in Sales tableDISTINCT(VENTAS[Numero Documento]) -- Distinct)
...but it didn´t work. Is showing the range of product prices.
