Forum Discussion

MRHUP's avatar
MRHUP
Frequent Visitor
4 years ago
Solved

How to place an extra column in a matrix (based on a string)?

Hi,   For an assignment I am looking for a solution, hopefully it is possible.... In a Matrix, after a regular count of the number of some  occurrences, I want to add an extra column for clarificat...
column
matrix
Matrix table
  • tamerj1's avatar
    tamerj1
    4 years ago

    MRHUP 

    Sure. But from the format settings make sure you don't select "measure on rows" and you have (compared to the given example) the category on rows and the color on columns. Also what are the empty rows that is shown in the last screenshot?

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi MRHUP 

try adding it as a measure 

SELECTEDVALUE ( Table[Id] )

MRHUP's avatar
MRHUP
Frequent Visitor
4 years ago

Hi, unfortunately this doesn't work. I only can add this as a value, not as a column or row. Doesn't have to be a problem I think, however, it still produces an extra row:

 

  • MRHUP's avatar
    MRHUP
    Frequent Visitor
    4 years ago

    Maybe a better picture of this outcome:

     

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Are you having the measures on rows or columns?

      • MRHUP's avatar
        MRHUP
        Frequent Visitor
        4 years ago

        I was only allowed to add the new measure for the A1 - A16 ID's (SELECTEDVALUE ( Table[Id] )) into the value field.