Forum Discussion

Saxon10's avatar
Saxon10
Post Prodigy
5 years ago
Solved

Measure in matrix row level

 

I have a two columns in data table which is area and result. I created new measure in same table which is status and I would like to bring it the area in column level, result in value column and new measure (status) row level in matrix visual table.

 

AREA

RESULT

DD1

WIN

DD1

WIN

DD1

WIN

DD1

WIN

DD1

WIN

DD1

WIN

DD2

LOSS

DD3

LOSS

DD3

LOSS

DD3

LOSS

DD3

LOSS

DD4

LOSS

DD5

LOSS

DD6

LOSS

DD7

LOSS

DD8

LOSS

 

 

 

 

  • You cannot add a measure in matrix row. (Like Mohammad_Refaei said )

    Have you every looked into "Show on rows" functionality for your needs? Just curious. 

7 Replies

  • You cannot add a measure in matrix row. (Like Mohammad_Refaei said )

    Have you every looked into "Show on rows" functionality for your needs? Just curious. 

    • Saxon10's avatar
      Saxon10
      Post Prodigy

      Thanks for your reply. I tried the option and its works for value column not im row level. 

      • sevenhills's avatar
        sevenhills
        Super User

        It has limitations and not work for all scenarios.
        Shared so that it is worth a look and see if you could change your visualization.
        Sorry, if this does not help your scenario. 

  • Mohammad_Refaei's avatar
    Mohammad_Refaei
    Solution Specialist

    You cannot add a measure in matrix row.

    You have to add a data field (column).

    • Saxon10's avatar
      Saxon10
      Post Prodigy

      thanks for your quick response.