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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
How do I create a new measure table to compare and retrieve the higher value and divide this value with quantity.
The result column is what I want my "measure" to be able to do. The data are all in the same table.
Eg:
Time Time Actual Time (Higher value) Quantiy Result
50 40 50 2 25
30 20 30 3 10
Solved! Go to Solution.
@ephramz , Create a new measure like
sumx(table, divide( if([Time1]>[Time2], [Time1], [Time2]),[Quantity]) )
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 103 | |
| 80 | |
| 63 | |
| 50 | |
| 45 |