Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Subtracting Value

Hi Team,   I have data,   expected Remaining value,     Thanks, KV's
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

again I'm sorry , I can't paste file, please see below screenshot,

 

V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi Anonymous ,

 

Please refer to:

Measure = 
VAR x = 
SUMX(
    FILTER( ALLSELECTED(Sheet7), [UID] = MAX([UID]) ),
    [Prod_Vol]
)
RETURN
[Prod_Stock]- x

Sample .pbix 

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi V-lianl-msft ,

     

    Thanks for you help,

     

    But [Prod_Vol] and [Prod_Stock] is separate table like Measures table. 

    Thanks,

    KV's

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Sorry, I can't understand what you're saying.

     

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