Forum Discussion

PieroCampilii's avatar
PieroCampilii
Regular Visitor
3 years ago
Solved

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 i...
  • PieroCampilii's avatar
    PieroCampilii
    3 years ago

    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's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi PieroCampilii 

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

PieroCampilii's avatar
PieroCampilii
Regular Visitor
3 years ago

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.