Matrix Table: Display the value on the Top Hierarchy only

[EvanGetsItDone]

Hi,
I needed to remove the repeating values (circled in red) 
the measure is Planted = CALCULATE(SUMX(value), ALL(Location), ALL(Sub Customer))

I just want the value to be shown on the top most and not repeat below. 

Thanks!

[v-zhangti · Accepted solution]

Hi, @EvanGetsItDone 

You can try the following methods.

[Planted] is a measure.

Measure = IF(HASONEVALUE('Table'[Sub Customer]),BLANK(),[Planted])

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bdehning]

How wouid I tweak the measure if i wanted location 2 to be on top so highest planted number was first and then decending the rest so location 1 in this case.  I all already have child values in hierarchy table

[EvanGetsItDone]

Related to this Issue.
https://community.powerbi.com/t5/Desktop/Matrix-Total-Value-Used-for-Another-Field/m-p/2889474#M9936...