Search code examples
powerbipowerbi-desktop

Backtracking data in power bi

I tried backtracking the values of one column based on the minimum values of another column in a new column. Description is given in image. Kindly suggest a formula to get the values as I have to apply it to other places too.

MIN_KBETR=
CALCULATE(
    MIN(ZMOB_TZONE_L1[KBETR]),
    ALLEXCEPT(
        ZMOB_TZONE_L1,
        ZMOB_TZONE_L1[LZONE],
        ZMOB_TZONE_L1[INCO1],
        ZMOB_TZONE_L1[WGBEZ]
    )
)

enter image description here

Solution

  • Can you please try this below-

    MIN_KBETR=

var min_kbter = 
CALCULATE(
    MIN(ZMOB_TZONE_L1[KBETR]),
    ALLEXCEPT(
        ZMOB_TZONE_L1,
        ZMOB_TZONE_L1[LZONE],
        ZMOB_TZONE_L1[INCO1],
        ZMOB_TZONE_L1[WGBEZ]
    )
)

return
CALCULATE(
    MIN(ZMOB_TZONE_L1[DISTZ]),
    FILTER(
        ALLEXCEPT(
            ZMOB_TZONE_L1,
            ZMOB_TZONE_L1[LZONE],
            ZMOB_TZONE_L1[INCO1],
            ZMOB_TZONE_L1[WGBEZ]
        ),
        ZMOB_TZONE_L1[KBETR] = min_kbter
    )
    
)