Forum Discussion
Add Measure Classifications to Column Field Well
v-achippa please remove this topic, this was not the solution I needed and I ended up going a different direction.
Hi garynorcrossmmc ,
Are this based on a column on your model or on a classification of each measure?
If you have a measure for each of the calculations using a filter on your table the best option is to have a single measure for Current and Prior and then use the column you use has filter on your measures to be the columns of your matrix this will automatically give you the filter you are looking for.
Can you explain hoe you built the matrix so I can point you to a more accurate option.
hi MFelix,
These are classifications of existing measures within the model. I realize that the scenario you mentioned is ideal, but it will not work for this user requirement.
The matrix is built like this. There are 2 dimensions in the 'Rows' field well and 8 measures in the 'Values' field well. They are all labeled Current or Prior, but they are 8 separate measures.
And how are the measures calculated? Are they all similar but with different filters or are they more complex?
Can you provide the syntax for some of them just to check
Hi MFelix, the measures are constructed differently and some are quite complex. Is there any way to create a column heading based on a measure name?
If not, I thought of a potential workaround for this, maybe you know the answer here. Is there a way to display an alias in a matrix column heading that when the visual is exported, the measure's name is shown?Hi garynorcrossmmc ,
In this case just follow this steps:
- Create a table with the following setup:
Order Group Metric Alias Group Sort 1 Global Female Metric 1 Current 1 2 Global Female Metric 2 Prior 1 3 Global Male Metric 3 Current 2 4 Global Male Metric 4 Prior 2 5 US Non-White Metric 5 Current 3 6 US Non-White Metric 6 Prior 3 7 US White Metric 7 Current 4 8 US White Metric 8 Prior 4 Replace the metrics should be replaced by the ones you have on your model and use on your matrix then create the following measure:
Matrix Values = SWITCH ( SELECTEDVALUE ( Table[Order] ), 1, [Measure1], 2, [Measure2], 3, [Measure3], 4, [Measure4], 5, [Measure5], 6, [Measure6], 7, [Measure7], 8, [Measure8] )Use the columns Group and Alias on the matrix columns and the Matrix values on the matrix,
The Group must be sorted by the Group Sort Column and the Metric column must be sorted by the Order Column