cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## 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.

1 ACCEPTED SOLUTION
Regular Visitor

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 4
Regular Visitor

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.

Super User

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

Regular Visitor

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.

Regular Visitor

Hi tamerj1!

Nothing

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors