Forum Discussion

Sergii24's avatar
Sergii24
Icon for Super User rankSuper User
5 years ago
Solved

Issue with evaluation context/context transition

Dear all,   I've got lost a bit in all types of filters and transitions of Power BI and would appretiate a lot your help! In my dataset I have columns for Stock and Orders in items that should be ...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Sergii24 

    Not clear about the model and the relationship. Try an approach like below

     

    Match (Stock) =

SUMX(
    VALUES(Stock[Items]) 
    VAR _NetStock = [Stock Qty] - [Open Orders]
    VAR _Result =
    IF(
        _NetStock >= 0,
        [Open Orders],
        [Stock Qty]
    )
    RETURN _Result
)

     

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Sergii24 

Not clear about the model and the relationship. Try an approach like below

 

Match (Stock) =

SUMX(
    VALUES(Stock[Items]) 
    VAR _NetStock = [Stock Qty] - [Open Orders]
    VAR _Result =
    IF(
        _NetStock >= 0,
        [Open Orders],
        [Stock Qty]
    )
    RETURN _Result
)

 

 

Sergii24's avatar
Sergii24
Icon for Super User rankSuper User
5 years ago

Fowmy , thank you very much! It looks like that outer SUMX is what was missing!

In my understanding once I wrote 2 separate measures for "Stock Qty" and "Open Orders" I was ready to use them together in a new, 3rd measure, having already a row context, which is wrong.
The correct way, instead, is to have another outer SUMX even in my third variable ("Match Stock") that is introducing row context for this new measure for the first time!

Thanks a lot for filling this gap in my knowledge! 🙂