cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Show Row Subtotal for Only One Row in Matrix

I have this data:

 Item Number Site Warehouse Location Inventory Physical 1 A ABC 11 10 1 A DFG 12 50 1 A PTN 15 100 1 B FF 22 150 1 B GG 25 200

And I am trying to figure out how I can have a matrix with the rows in the following order: Item Number > Site > Warehouse > Location, and then Inventory Physical in the values with stepped layout off.

Where it gets tricky is I only want to see the sum of inventory physical for the item number level, I don't want to see totals for site, warehouse, or location. I have went through all of the matrix settings and can't figure out how to achieve this.

1 ACCEPTED SOLUTION
Community Support

Hi @CC25 ,

You can try below formula and turn off stepped layout icon.

``````TotalInventoryPhysical =
SUM('Table'[Inventory Physical])
``````
``````DisplayInventoryPhysical =
IF(
ISINSCOPE('Table'[Item Number]),
[TotalInventoryPhysical],
BLANK()
)
``````

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Community Support

Hi @CC25 ,

You can try below formula and turn off stepped layout icon.

``````TotalInventoryPhysical =
SUM('Table'[Inventory Physical])
``````
``````DisplayInventoryPhysical =
IF(
ISINSCOPE('Table'[Item Number]),
[TotalInventoryPhysical],
BLANK()
)
``````

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

In the matrix settings, under Row subtotals, you can switch on 'Per row level' and that will let you select which levels get a sub total.

You would select the rows you want to disable it on in the 'Row level' dropdown then turn off 'Show Subtotal'

Frequent Visitor

When I turn off subtotal for all rows except item number, it doesn't work correctly, it is still somehow managing to sum by the last row, "Location".

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors