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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
I'm trying to write a measure that calculates the margin.
I wrote the code and am getting the following error:
A single value for column 'amount' in table 'Module Sales with Inventory' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
I have attached the measure below. Any help would be greatly appreciated.
Solved! Go to Solution.
Hi,
Please try something like below.
Margin =
DIVIDE (
SUMX (
'Module Sales with Inventory',
'Module Sales with Inventory'[amount] - 'Module Sales with Inventory'[cost amount]
),
SUMX ( 'Module Sales with Inventory', 'Module Sales with Inventory'[amount] )
) * 100
Hi,
Please try something like below.
Margin =
DIVIDE (
SUMX (
'Module Sales with Inventory',
'Module Sales with Inventory'[amount] - 'Module Sales with Inventory'[cost amount]
),
SUMX ( 'Module Sales with Inventory', 'Module Sales with Inventory'[amount] )
) * 100
That seems to have worked!
Thank you so much!