Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix

Hello, I got this Matrix with this information:   And i would like to have the information on the row. For exemple this:   But I don't know what to put in my rows to have this b...
Need Help
  • SivaMani's avatar
    SivaMani
    5 years ago

    Anonymous,

     

    1. Create a Table with the Enter Data Option with a column (MeasureName) that will have three rows(based on the example) - Production, Sant Effet, and Production nette
    2. Create a measure: 
    Value =
VAR SelValue =
    SELECTEDVALUE ( Table[MeasureName] )
RETURN
    SWITCH (
        TRUE (),
        SelValue = "Production", SUM ( MainTable[Production] ),
        SelValue = "Sant Effet", SUM ( MainTable[Sant Effet] ),
        SelValue = "Production nette", SUM ( MainTable[Production nette] )
    )

     3. Add MeasureName to Rows and Value Measure to Column

     

    It will work.

Pragati11's avatar
Pragati11
Super User
5 years ago

HI Anonymous ,

 

Under ROWS section you can move only a column.

Do you have something in your data like a categorical column with 3 values as categories that you have moved the measures for?

I am assuming that under VALUES section you moved 3 measures.

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Pragati11 Hello, no as my 3 values are measure I don't have a categorical column with my values name.

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    HI Anonymous ,

     

    In that case follow the solution mentioned by SivaMani using the approach of a disconnected table.

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Pragati11 ok thank you, but as I reply to him it will not re calculate my values if I change the filters no? 

      • Pragati11's avatar
        Pragati11
        Super User
        5 years ago

        Hi Anonymous ,

         

        Ideally it should not.

        Just try and let me know how it works.

         

        Thanks,

        Pragati