SUM a table variable

lpriceFTW · ‎01-31-2023

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 · ‎01-31-2023

Hi,

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

SUMX( _filterFen, [AMT] )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

lpriceFTW · ‎01-31-2023

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

Jihwan_Kim · ‎01-31-2023

Hi,

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

Thanks.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

lpriceFTW · ‎02-01-2023

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.