Create conditional formatting between two tables

[Elie_HUCHET]

Hello,
I would like to create conditional formatting from a formula. I have already created a formula allowing this. When a field in the "Order status" (Statut de la commande) column is either "Request made"(Demande faite), or "Processing in progress" (Traitement en cours) or "Order made"(Commande faite) then a value applies.

The problem is that I would like to cross two tables in this same layout conditional form.
If the available stock <=Minimum stock and it has no order status then it has the number 8 for example. The problem is that this formula does not take despite a SUM to link the two tables.

As you can see below this screenshot, we have two cases (highlighted in yellow and circled in red) where our available stock is less than our minimum stock and where no process has been started and yet it does not appear in red.

Thank you for your help

[Elie_HUCHET]

THANK YOU IT'S OK!! 🙂 

[v-kkf-msft · Accepted solution]

Hi @Elie_HUCHET ,

Please try the measure.

MeF =
VAR color =
    SWITCH (
        SELECTEDVALUE ( 'Commande fournisseur'[Statut de la commande] ),
        "Demande faite", 1,
        "Traitment en cours", 2,
        "Commande faite", 3,
        "Recue", 4
    )
RETURN
    IF (
        color <> BLANK (),
        color,
        IF (
            SUM ( 'Extraction detaillee'[Stock Disponible] )
                < SUM ( 'Extraction detaillee'[Mini] ),
            8,
            0
        )
    )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.