Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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().
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |