Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 part...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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