undefined

[Anonymous]

Tengo una serie de pedidos, el total de unidades por cada pedido es distinta, en un pedido puede tener 3 productos o 2 productos o solo 1 productos
necesito un tabla o medida que me muestre la participacion por los totales posibles
ejemplo:

Cantidades
productos pedidos
posibles cantidad pedidos
1 78% de los pedidos
2 10 % de los pedidos
3 12 % de los pedidos

es decir que el 78% de los pedidos solo contiene un producto

[Anonymous · Accepted solution]

Hi @Anonymous ,

You may follow @amitchandak 's suggestion to see if it helps.

And I have built a data sample for test:

 Please follow the steps.

1. Firstly create a Number list table:

Quantities = GENERATESERIES(1,5,1)

2. Calculate how many products per Order:

Count = CALCULATE( DISTINCTCOUNT('Table'[Product]),ALLEXCEPT('Table','Table'[Order]))

3. Calcualte the ratio:

Ratio = 
var _t= SUMMARIZE('Table','Table'[Order],"A",[Count])
RETURN COUNTROWS(FILTER(_t,[A]=MAX('Quantities'[Value])))  / DISTINCTCOUNT('Table'[Order])

Final output:

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

[amitchandak]

@Anonymous , Are you looking for Measure segmentation

Bucket/Segment code
measure
Measure = Count(Table[productid]) //

new Table
bucket = Generateseries(1,100,1)

new Measure =
Countx(filter(Values(Table[user]), [Measure ] = max(bucket[Value])), [User])

Now you can calculate %

divide([new Measure ], calculate([new Measure], allselected()) )

refer if needed

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ