Is Custom Subtotal in Matrix Visual possible?

[ERing]

Is it possible to create a custom subtotal line in a matrix visual? In the example below (taken from the web) I would want to create a subtotal for Camcorders, Cameras & Camcorders Accessories, and Digital Cameras.

Is this possible?

So the totals in this example would be.

Subtotal: Camcorders, Cameras & Camcorders Accessories, and Digital Cameras.

Digital SLR Cameras:

Total: Camcorders, Cameras & Camcorders Accessories, and Digital Cameras

[Kris2x5]

I use the ProfitBase visual to add custom subtotals.  

Store Link: https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000642?tab=overview

[lbendlin · Accepted solution]

There are multiple ways to accomplish this.  The safest would be to add another category level.

Otherwise read about ROLLUPADDISSUBTOTAL()

[ERing]

@lbendlin Adding another category level can be done in PowerQuery, right? I would add a conditional column that defines the 3 subcategories as a single category?

[lbendlin]

correct. you can also do that in DAX if you want, or via Groups.