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.

SivaMani's avatar
SivaMani
Resident Rockstar
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    SivaMani Thank you but if I do it, the matrix will not be changing with a filter in my report right?. For exemple if I change a filter in my report it would not calculate again my measure Production, Sans Effet and Production nette and display the correct values. It will display the old values. To information, my 3 measures can be filter thanks to 2 columns, columns "X" and "Y". Can we had a line of code in your code to allowed the matrix to recalculate the values whena filter changed?

    Thanks