Forum Discussion

Felizzpe's avatar
Felizzpe
New Member
1 year ago
Solved

Calculated column value based on another column and rows

Greetings,  I'm trying to make a calculated column that shows the production order status based on the status from all other production orders of the same group. (Production orders have groups, so...
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    hi Felizzpe ,

     

    try like:

    column =

    VAR _list =

    CALCULATETABLE(

        VALUES(data[Location]),

        ALLEXCEPT(data, data[Order Group])

    )

    VAR _result =

    IF(_list = "Finished", "Ready", "Not ready")

    RETURN _result

Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
1 year ago

Hello Felizzpe,

 

Can you please try this approach:

Order Status = 
VAR CurrentGroup = ProcessoAtualReal[Grupo_Faturamento]
VAR IsAnyOrderNotReady =
    CALCULATE(
        COUNTROWS(
            FILTER(
                ProcessoAtualReal,
                ProcessoAtualReal[Grupo_Faturamento] = CurrentGroup &&
                ProcessoAtualReal[Processo_Atual_Desc] <> "READY FOR DISPATCH"
            )
        )
    ) > 0
RETURN
IF(
    ISBLANK(CurrentGroup),
    BLANK(),
    IF(
        IsAnyOrderNotReady,
        "NOT READY",
        "READY FOR DISPATCH"
    )
)