Forum Discussion
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...
Anonymous,
- 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
- 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.
