Matrix conditional formating based on measure

[Anonymous]

Good day,

I would like to define a background color of matrix entry based on measure. Inside measure I plan to compare 3 entries of that matrix like A, B and C. If they equal - change a color. BUT I can't see related items inside, like in the format like Database[Field], only other measures instead.

How should I act? Thank you in forward.

[Icey]

Hi @Anonymous ,

Is this problem sloved?

If it is sloved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Anonymous]

Looking in to it 🙂 Will get back to you as soon as I'm done. Very grateful.

It seems that I need to compare current value with another one in the matrix. How this could be achieved in DAX calculated column context?

[Icey]

Hi @Anonymous ,

Is the result you want like the screenshot below?

If so, you can create your column and measures like so:

column:

Index =
IF (
    'Table (2)'[Product] = "P1",
    1,
    IF ( 'Table (2)'[Product] = "P2", 2, IF ( 'Table (2)'[Product] = "P3", 3, 4 ) )
)

measure:

Measure =
VAR PreIndex =
    MAX ( 'Table (2)'[Index] ) - 1
VAR NextIndex =
    MAX ( 'Table (2)'[Index] ) + 1
VAR PreSales =
    CALCULATE (
        SUM ( 'Table (2)'[Sales] ),
        FILTER (
            ALLEXCEPT ( 'Table (2)', 'Table (2)'[Country] ),
            'Table (2)'[Index] = PreIndex
        )
    )
VAR NextSales =
    CALCULATE (
        SUM ( 'Table (2)'[Sales] ),
        FILTER (
            ALLEXCEPT ( 'Table (2)', 'Table (2)'[Country] ),
            'Table (2)'[Index] = NextIndex
        )
    )
VAR Condion1 =
    IF (
        MAX ( 'Table (2)'[Sales] ) = PreSales
            && MAX ( 'Table (2)'[Sales] ) = NextSales,
        1,
        0
    )
RETURN
    Condion1

Measure 2 =
IF (
    SUMX ( ALLEXCEPT ( 'Table (2)', 'Table (2)'[Country] ), [Measure] ) <> 0,
    1,
    0
)

This is my PBIX file.

Best Regards,
Icey

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

[mauriciosotero]

Hi good day for u 2,

Can you post an example?

[Anonymous]

Here comes the example.

https://1drv.ms/u/s!Aj8B8cjnRANvwKF10wTGv_0yYTd6Ww?e=1Affrl

In it I would like to decide about color based on Measure (which is now equal to 0) if 22-41, 32-41 and 42-41 are equal.