Adding A Total Row to Table with Calculated Columns

[Anonymous]

Hi All!

I have a table where I want to show totals for each column, but it seems the Total option only works for non-calculated columns. The only thing I can think would be to created Measurements and add them as rows.

Any help would be much appreciated, thanks!

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

In my table visual, i can get all the sum total of my columns once I enbale the Totals option in Format pane. What is your datastruct or you add the measures in your visual? Could you please share your pbix to me to have a check?

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank