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
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity 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
    Icon for Community Support rankCommunity 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.