Ticket of purchase range

[Miguelcrz]

Hello, i'm trying to do ranges to separate the purchase ticket of my clients.

The measure of the ticket is this: 

Ticket = divide(sum(Fact_VentaDet[SALES]);sum(Fact_VentaDet[NUMBEROFTRANSACTIONS]))

I need to have this:

Thanks 🙂

[v-jayw-msft]

Hi @Miguelcrz ,

We need more information, as i didn't see the measure Ticket in your picture and what is the rango de tickets? Rankx? What are N` Clientes and Share%? Are they the sum of 1-15, 16-30, etc...?

Can you provide some sample data to us?

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Olá @Miguelcrz ,

Is that a count of tickets on the left or the age of your clients?

In case of age I would advise you to create a calculated column using an if with 5 clauses.

Best Regards,

DR

[Miguelcrz]

Hello @Anonymous ,

Is the range of tickets i would like to have.

1) Ticket range: - 15

2) Ticket range: 16 - 30

Thanks!

[Anonymous]

Can you send a sample of your raw data with no personal or sensitive information just to realize how your data is structured and what can/should you do.

Best Regards,

DR