Forum Discussion
SUM a table variable
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!
4 Replies
Hi,
When trying to calculate SUM of a column in a VAR table, try something like,
SUMX( _filterFen, [AMT] )
Does not appear to work. Did I do that correctly?
Hi,
Please share the sample pbix file's link, and then I can try to look into it.
Thanks.
