Skip to main content
cancel
Showing results for 
Search instead 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

Reply
PieroCampilii
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 

PieroCampilii_0-1686325805729.png

Pr_DOC#_DIF_SKU#.png

Order Number in Sales Table

 

Pr_SalesRange.png

Sales Range Table

Pr_DAX_SalesRange.png

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

Pr_DAX_SalesRange_RingChart_Error.png


Would like to have it like this one

Pr_good.png



Thanks in advance for any help.

1 ACCEPTED SOLUTION
PieroCampilii
Regular Visitor

I did it. 
Solution was to creat a new table with Order Only and filter that one.

PieroCampilii_0-1686753313785.png

I'm new to all this so congrats to myself haha!

Feels like progresing.



View solution in original post

4 REPLIES 4
PieroCampilii
Regular Visitor

I did it. 
Solution was to creat a new table with Order Only and filter that one.

PieroCampilii_0-1686753313785.png

I'm new to all this so congrats to myself haha!

Feels like progresing.



tamerj1
Super User
Super User

Hi @PieroCampilii 

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

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.

Pr_Distinct.png

Hi tamerj1!

Nothing 

Pr_justThis.png

 

Helpful resources

Announcements
Fabric Community Conference

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.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

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