Add Measure Classifications to Column Field Well

[garynorcrossmmc]

Hi all,

I'm trying to group the measures in the matrix visual shown below (labeled 'Current' / 'Prior') by the groupings circled in red ('Global Female' / 'Global Male' / 'US Non White' / 'White').  Is this possible?  I currently have these set up a text boxes, but the users will want to see these column groupings in the exported data table, so I need to add groupings to the 'Columns' field well.

[garynorcrossmmc · Accepted solution]

@v-achippa please remove this topic, this was not the solution I needed and I ended up going a different direction.

[v-achippa]

Hi @garynorcrossmmc,

Thank you for the response, if you have found any solution, I request you to please post it here and kindly mark it as accept as solution so that other community members will find it more easily.

Thanks and regards

Anjan Kumar Chippa

[MFelix]

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.

[garynorcrossmmc]

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.

[MFelix]

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

[garynorcrossmmc]

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?

[MFelix]

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

[v-achippa]

Hi @garynorcrossmmc,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @MFelix for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue?
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @garynorcrossmmc,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue?

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa