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 ,
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
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
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