SUM a table variable

[lpriceFTW]

I want to sum the amount column in my table variable:

As you can see, I create a table stored in a variable "filterFen". Within this table there is a column called "AMT" containing numeric amounts.

I simply want to sum all of those amounts and return them in variable "cashSum".

Why am I unable to do this and how can I resolve?

Thanks!

[Jihwan_Kim]

Hi,

When trying to calculate SUM of a column in a VAR table, try something like,

SUMX( _filterFen, [AMT] )

[lpriceFTW]

Does not appear to work. Did I do that correctly?

[Jihwan_Kim]

Hi,

Please share the sample pbix file's link, and then I can try to look into it.

Thanks.

[lpriceFTW]

How do I do that? I do not have a pro license, so I cant share it through the PBI service, and my organization restricts access to files saved in our OneDrive so I can't share it that way either.