How do I color code Calculation Groups with over 20+ Measures in Matrix?

Hi blaj 

You can create a new table, put the names of the measures to the table. such as the following.

Then crearte a new measure.

Measure =
SWITCH (
    SELECTEDVALUE ( 'Table'[Column1] ),
    "Sales", [Sales],
    "Orders", [Orders],
    "Sales/Customer", [Sales/Customer],
    "Sales/Order", [Sales/Order]
)

Then put the Column1 of the table to the row and put the measure to the value in matrix.

Then create a new measure2 to format the measure

Measure 2=
SWITCH ( TRUE (), [Measure] <= 0.05, "red", [Measure] > 0.05, "green" )

Then put the measure2 to the conditional formatting of measure.

Then it can work.

Best Regards!

Yolo Zhu

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