Hiding totals for top level hierarch

[sm_accordion]

I have the following matrix in Power BI Desktop with Division and SKU on the Rows and Sales on the Values:

I have hidden the Division subtotals.  When I collapse by Division, I get the following:

Is there a way I can suppress the Division totals in this view as well?  I want to just show the three divisions with blanks next to the labels.  I can't really use HASONEVALUE in a measure on the SKU column as Division-3 only has one SKU.  I can't use HASONEVALUE on the Division column as it will suppress the values in the expanded view (first picture above) which I don't want.

Any ideas would be appreciated.

[JarroVGIT · Accepted solution]

You can use HASONEFILTER like this:

Sales1 = IF(HASONEFILTER('Table'[SKU]), AVERAGE('Table'[Sales]), "")

With this result:

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[sm_accordion]

Brilliant, it works like a charm.  Thanks a lot!  Nice trick to use "" instead of Blank().