Forum Discussion
Helper IMATRIX measures in rows with 2 versions
You could use enter data to create a table with a single column with 2 rows: Actual and Target.
Put this in your Columns seciton of the matrix.
Create a measure for each of the 3 types:
Sales =
If(SelectedValue(table[type]) = "Actual", [Actual Sales], [Target Sales])
Repeat for each measure and add them into values.
Then use the Values - Options - Switch values to rows
Super UserYou could use enter data to create a table with a single column with 2 rows: Actual and Target.
Put this in your Columns seciton of the matrix.
Create a measure for each of the 3 types:
Sales =
If(SelectedValue(table[type]) = "Actual", [Actual Sales], [Target Sales])
Repeat for each measure and add them into values.
Then use the Values - Options - Switch values to rows
Helper IIt worked thank you very much! 🙂