Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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().
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |