Forum Discussion
Helper IMATRIX measures in rows with 2 versions
Hello,
I have several measures with the same setup (only difference is some are for TARGET version, some are for ACTUAL version) and I want to reorder a matrix table but I can not do it as I wish. Could you help me how to put measure with names in rows? I tried with the VALUE SWITCH TO ROWS option, but the problem with it is that it puts actaul and target below each other and I want them next to each other. Is it possible?
This is 1 dax example:
Thank you in advance!
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
2 Replies
- SamWiseOwl
Super User
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
Evelin_It worked thank you very much! 🙂