topic Re: Sales Range and Ring Chart Error? in DAX Commands and Tips

Sales Range and Ring Chart Error?

PieroCampilii — Fri, 09 Jun 2023 16:41:58 GMT

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.

Re: Sales Range and Ring Chart Error?

tamerj1 — Fri, 09 Jun 2023 16:13:36 GMT

Hi PieroCampilii

what to you get when you remove document number from details?

Re: Sales Range and Ring Chart Error?

PieroCampilii — Fri, 09 Jun 2023 16:32:00 GMT

Hi tamerj1!

Nothing

Re: Sales Range and Ring Chart Error?

PieroCampilii — Fri, 09 Jun 2023 16:51:44 GMT

tamerj1

I tryed this other DAX scenario where [tickets] is my distinct of sales

CALCULATE([Ventas en Moneda], -- a sumx of qty * net price

ALL(VENTAS[Numero Documento]), -- Order Number in Sales table

DISTINCT(VENTAS[Numero Documento]) -- Distinct

)

...but it didn´t work. Is showing the range of product prices.

Re: Sales Range and Ring Chart Error?

PieroCampilii — Wed, 14 Jun 2023 14:40:36 GMT

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.