Group Measures

[VasTg]

Hello,

I could not find the answer I am looking for in the forum, so creating a new thread.

Is there a way to basically group unrelated measures into some custom category?

I have a matrix like below.

Attribute 1	Attribute 2	Measure 1	Measure 2	Measure 3	Measure x	Measure y	Measure z

Expected Results:

How do I group Measure 1,2,3 to AAA and x,y,z to BBB. I don't want to use a slicer as well.

Appreciate the help.

[Icey · Accepted solution]

Hi @VasTg ,

You can try this:

1. Create a new table.

2. Create a measure.

Measure =
IF (
    MAX ( 'Table'[Measure Name] ) = "Measure 1", [Measure 1],
    IF (
        MAX ( 'Table'[Measure Name] ) = "Measure 2", [Measure 2],
        IF (
            MAX ( 'Table'[Measure Name] ) = "Measure 3", [Measure 3],
            IF (
                MAX ( 'Table'[Measure Name] ) = "Measure x", [Measure x],
                IF (
                    MAX ( 'Table'[Measure Name] ) = "Measure y", [Measure y],
                    IF ( 
                        MAX ( 'Table'[Measure Name] ) = "Measure z", [Measure z] )
                )
            )
        )
    )
)

3. Create a Matrix visual and keep "Stepped layout" unselected.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ssze]

Hi @Icey, your recommendation is amazing and helped with what i need as well!

Just one more refinement I wonder if it is possible to have each measure with different decimal places? I seem to only be able to get everything in the same format e.g. 2 decimal places but i want some columns as whole numbers and some decimal places!

Thanks heaps in advance!