Conditional formatting in matrix for opposite KPI's

[Anonymous]

Hi everyone. I wrote below 2 measures to color KPI's is matrix, however, difficulty I faced is that, one of the KPI's is better than value is higher than monthly target, and second is better than value is lower than monthly target. I tried to use FILTER to differentiate the measure behaviour according to filtered KPI, but it works only for the one KPI.

Any ideas how could I combine these in one measure?

.Format KPI1_lower_better = SWITCH(TRUE(), 
    DIVIDE(
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI1 (mins)"),
                     1 * 'Merge (value)'[KPI Actual Value]),
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI1 (mins)"),
                     1 * 'Merge (value)'[KPI Target Value])) < 0.75 , "#D88B84",
    DIVIDE(
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI1 (mins)"),
                     1 * 'Merge (value)'[KPI Actual Value]),
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI1 (mins)"),
                     1 * 'Merge (value)'[KPI Target Value])) <= 0.99 , "#D88D84",
    DIVIDE(
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI1 (mins)"),
                     1 * 'Merge (value)'[KPI Actual Value]),
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI1 (mins)"),
                     1 * 'Merge (value)'[KPI Target Value])) > 0.99 , "#84D8A3"
    )


.Format KPI2_higher_better = SWITCH(TRUE(), 
    DIVIDE(
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI2 (hours)"),
                     1 * 'Merge (value)'[KPI Actual Value]),
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI2 (hours)"),
                     1 * 'Merge (value)'[KPI Target Value])) < 0.75 , "#84D8A3",
    DIVIDE(
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI2 (hours)"),
                     1 * 'Merge (value)'[KPI Actual Value]),
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI2 (hours)"),
                     1 * 'Merge (value)'[KPI Target Value])) <= 0.99 , "#D88D84",
    DIVIDE(
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI2 (hours)"),
                     1 * 'Merge (value)'[KPI Actual Value]),
        MAXX(
            FILTER('Merge (value)', 'Merge (value)'[KPI] = "KPI2 (hours)"),
                     1 * 'Merge (value)'[KPI Target Value])) > 0.99 , "#D88B84"
    )