Select problem

[RodolfoLima]

Can you see what am I doing wrong?

SUM(
SELECT(
"Expenditure Details"[Total Order Amount],
([expenditure_id] = [_THISROW].[expenditure_id]), FALSE))

I got 

"SELECT has invalid inputs" error message.

This column "Total Order Amount" is a virtual column from another table, with this formula:

[Quantity] * ([Price Per Unit] - [Discount])

[scott192 · Accepted solution]

Try removing the quotes around your table name so that it says

Expenditure Details[Total Order Amount]

[scott192]

And...you could also try this instead...

SUM([Related Expenditure Details][Total Order Amount])

Instead of your Sum(Select()) statement...

[RodolfoLima]

Thank you!