0
votes

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

enter image description here

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.

1

1 Answers

0
votes

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:

enter image description here

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.

enter image description here

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)

enter image description here