Help to define Dax Formula

[mrzain14]

Hello,

I'm pretty new to using Dax in PowerBI,

I would like to calculate the remaining production qty by calculating (SUM order qty (table 1)) - (SUM production output(table 2)).

rules if the result <0, will be stored as "0" avoid minus.

What Dax formula do I need to use?

Thank you

[Daniel29195 · Accepted solution]

@mrzain14 

measure   = 

var s = sum(table_1[order qty_col_name]) - sum(table_2[production_output_col_name])

return

switch(

true(), 

s < 0 , 0 , s)

let me know if this works for you . 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Daniel29195 · Accepted solution]

@mrzain14 

measure   = 

var s = sum(table_1[order qty_col_name]) - sum(table_2[production_output_col_name])

return

switch(

true(), 

s < 0 , 0 , s)

let me know if this works for you . 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[mrzain14]

Hi @Daniel29195 , I still got error like this

[Daniel29195 · Accepted solution]

@mrzain14 

you wrote var.s( 

modify it  to :  var S =  

[mrzain14]

Thank you