Forum Discussion

non23's avatar
non23
Icon for Helper I rankHelper I
2 years ago
Solved

Do not repeat values (measure) in Matrix

Hi everyone,

 

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

  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    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

3 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      FarrukhData
      Frequent Visitor
      1 year ago

      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. 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi non23 can you please share the data.