Forum Discussion

EvanGetsItDone's avatar
EvanGetsItDone
Icon for Helper I rankHelper I
3 years ago
Solved

Matrix 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 ...
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

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's avatar
    bdehning
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    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