Subtotal problems

[rpinxt]

Quick questions as I keep running into this.

When using a matrix I want to no show subtotals for every line (as that field is unique so it makes no sense!) but I do want to see the grandtotal.

Somehowe if I switch off row subtotals I also have no grand totals....

[Anonymous]

Hi @rpinxt ,

Please try:

Measure 2 = IF(ISINSCOPE('Table'[Column1])<>ISINSCOPE('Table'[Column2]),BLANK(),[Measure])

Or:

Measure 3 = IF(ISINSCOPE('Table'[Column1])<>ISINSCOPE('Table'[Column2]),BLANK(),SUMX(SUMMARIZE('Table','Table'[Column1],'Table'[Column2]),[Measure]))

Result:

The PBIX file is attached for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[rpinxt]

Ok thanks @Anonymous 

But if I'm correct then you only can do this with a measure?
And then you will always have a blank row?

Or is that only here because you also have the measure with subtotal in and maybe stepped layout on.

So there is no settings option like in excel where subtotals and grand totals are seperately from eachother to control?

[Anonymous]

Hi @rpinxt ,

Yes, more cannot be done at this time.😥 Please vote for this idea:
Toggles for Sub-Totals and Grand-Totals on Matrixes

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data