Forum Discussion

gbarr12345's avatar
gbarr12345
Post Prodigy
2 years ago
Solved

Measure query

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...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    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
Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

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
  • gbarr12345's avatar
    gbarr12345
    Post Prodigy
    2 years ago

    That seems to have worked!

     

    Thank you so much!