Forum Discussion
undefined
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
3 Replies
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
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.
