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

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
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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