topic Re: Do not repeat values (measure) in Matrix in DAX Commands and Tips

Do not repeat values (measure) in Matrix

non23 — Tue, 23 Jul 2024 05:08:01 GMT

Hi everyone,

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

Re: Do not repeat values (measure) in Matrix

bhanu_gautam — Tue, 23 Jul 2024 05:17:33 GMT

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

Re: Do not repeat values (measure) in Matrix

Anonymous — Tue, 23 Jul 2024 06:04:35 GMT

Hi non23 can you please share the data.

Re: Do not repeat values (measure) in Matrix

FarrukhData — Tue, 08 Jul 2025 01:45:11 GMT

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.