Sales Range and Ring Chart Error?

[PieroCampilii]

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.

[PieroCampilii · Accepted solution]

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.

[tamerj1]

Hi @PieroCampilii 

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

[PieroCampilii]

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.

 

[PieroCampilii]

Hi tamerj1!

Nothing