Forum Discussion

Deeks's avatar
Deeks
Frequent Visitor
3 years ago

Please help - calculation incorrect for backlog

Hi,  I am trying to calculate the amount that should be "backlog", so it has not been shipped yet. My current formula adds up everything up to the current week's date. I'd like it to add any amount ...
DAX Measures
Gengar's avatar
Gengar
Resolver I
3 years ago

Hi Deeks ,

 

Try something like this:

Backlog Amount2 = CALCULATE ( [OverallValue], FILTER('OOR','OOR'[New/Backlog] = "Backlog"&&[isShipped]=FALSE())) + 0

Best regards,

Gengar

 

Deeks's avatar
Deeks
Frequent Visitor
3 years ago

Hi Gengar 
Thank you for your response, it didn't quite work as I need it to, but I have found a workaround for this now, using original code.