Forum Discussion

UserMFA's avatar
UserMFA
Frequent Visitor
2 years ago
Solved

Matrix duplicate total value to child

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 ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Alf94's avatar
    Alf94
    2 years ago

    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,

Alf94's avatar
Alf94
Solution Supplier
2 years ago

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,