The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
122 | |
89 | |
75 | |
55 | |
45 |
User | Count |
---|---|
135 | |
121 | |
77 | |
65 | |
64 |