Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
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.
Thank you so mucho.
@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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.