Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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! 🙂
Proud to be a Super User!
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! 🙂
Proud to be a Super User!
Brilliant, it works like a charm. Thanks a lot! Nice trick to use "" instead of Blank().