topic Re: Summing a column in table visual in DAX Commands and Tips

Summing a column in table visual

jvaught — Wed, 07 Apr 2021 19:59:17 GMT

I'm sure this has been asked a bunch of times: How do I get the total to show up for the Amount value? If I use the "Sum" aggregation it give me too large of a number.

I have searched the forum, but I can't figure out how to phrase my question in a way that the search results give me a good result. It's almost like it's too basic a question! Every search I do gives me answers on doing much more complicated things.

Re: Summing a column in table visual

Anonymous — Wed, 07 Apr 2021 21:48:05 GMT

jvaught

Nothing can be said about it because you have not shown us the model and how the measure is written.

Re: Summing a column in table visual

jvaught — Thu, 08 Apr 2021 03:40:58 GMT

"Amount" is raw data. "Sum of Amount" is just selecting "Sum" in the aggregation choices for that column.

I don't know what else to provide, the model has a whole bunch of things unrelated to my question and I've yet to figure out how to provide info without giving away all of my client's data!

Let's try this: I added an index upstream to give me a column I can show you which will also force the table to display not aggregated.

You can see that there are multiple rows with similar amounts (e.g., two rows with Amount = $15k). So without the index the table collapses to what I showed in the OP.

It makes sense to me that "Sum of Amount" will show $30k because there are two rows in the source data with the amount of $15k. My question is how can I get a column total on the "Amount" column which sums the row values shown, namely only one occurrence of the $15k value, one occurrence of the $17k value, etc. Like this:

I am doing my best to provide the info needed, but I don't really know what to provide. If there is still not enough here for you to move the ball down the field with me, maybe you can ask a clarifying question or two. Thanks in advance.