Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello All,
I have a Power BI that shows Matrix like below
Iwont to have blank values on childs and only show the total to the parent (here in Yellow)
Any help please or suggestion to do this
thank you guys !!
Solved! Go to Solution.
Hi @UserMFA ,
Let's assume that the children in your matrix come from a field called City. I think you can try a measure like the following:
IF(
NOT( HASONEVALUE( Table[City] ) ),
[Write your measure]
)
If I answered your question, please mark my post as a solution.
Best,
Hi @UserMFA ,
Let's assume that the children in your matrix come from a field called City. I think you can try a measure like the following:
IF(
NOT( HASONEVALUE( Table[City] ) ),
[Write your measure]
)
If I answered your question, please mark my post as a solution.
Best,
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.