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.
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.
You can get this without having to create an extra measure or use DAX.
I used a table and was able to get the following result that fits your requirements:
Check #1 - Make sure the values setting for only the third column Valor Total is set to Sum in the pull down (see image). The two other columns you should set to Don't summarize.
Check #2 - Click on the table and make sure in the Paint roller settings for the visual, that the total setting is turned on (see image)
