Forum Discussion
Helper IMatrix Table: Display the value on the Top Hierarchy only
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!
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.
3 Replies
EvanGetsItDone
v-zhangtiCommunity Support
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
Post Prodigy
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