Show grand total for last column only

[webportal]

Hello,

Is it possible to show the Grand Total for the last column only?

The other columns cannot be added.

I can either work with a table or matrix.

[Phil_Seamark · Accepted solution]

Hi again @webportal

Just create calculated measures over the columns that you don't want the total.

Then wrap the new measure to only show values on the rows.  You'll need to point the [Category] column to something that you are actually using in your table visual (one of the ones we can't see)

Sum of Quant. = 
    IF(
        ISFILTERED('Códigos e valores'[Category]),
        SUM('Csv'[Quant.])
      )

[webportal]

LOL, I was looking on the Format tab.
But with DAX you can solve anything!
Thanks!

[webportal]

Actually, I'm trying with:

Measure = IF(ISFILTERED('Table'[Category]);SUM([Quant.]))

This hides the grand total but then it doesn't summarize rows by Category, ie, it shows all the items.

So all rows get a 1 for the measure above.