cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

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

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors