Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet 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]) )
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.