Do not repeat values (measure) in Matrix

[non23]

Hi everyone,

Is there a way to avoid repetition of values (Measure) in Matrix? 2nd view is the one I want to achieve.

[Anonymous]

Hi @non23 can you please share the data.

[bhanu_gautam · Accepted solution]

@non23 , Create a new measure for this using rank

Units_Display =
IF (
ISINSCOPE('YourTable'[Size]),
IF (
RANKX(
ALLSELECTED('YourTable'[Size]),
CALCULATE(SUM('YourTable'[Units (Measure)])),
,
ASC,
DENSE
) = 1,
SUM('YourTable'[Units (Measure)]),
BLANK()
),
SUM('YourTable'[Units (Measure)])
)

Instead of Unit(Measure)  use this in matrix view

[FarrukhData]

@bhanu_gautam 
what if we have text data? How do we do that?
for example 
orange are the rows I can stop them from repeating.
I cannot stop values(Black) from repeating.