undefined

[Anonymous]

I have a series of orders, the total number of units for each order is different, in an order you can have 3 products or 2 products or only 1 product
I need a table or measure that shows me the participation by the possible totals
example:

quantities ordered

products possible            quantity ordered
1                                     78% of orders
2                                    10% of orders
3                                     12% of orders

that is to say that 78% of the orders only invoiced one product

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

>> 

Is the data in this table your original data? If not, please share some sample data and the expected result.

Best Regards,

Community Support Team _Tang

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

[Anonymous]

Thank you so mucho.

[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