Backlog report by sub-categories and category

[amirel01]

I am trying to create a backlog report by assembly and then rolled up by customer. To start I have a promise value running total (by date) and a production value running total (by date). Backlog = IF('[Production Value Running Total]-Promise[Promise Value Running Total]>0,0,-([Production Value Running Total]-Promise[Promise Value Running Total])). All of these are DAX measures. 

The results I get for the assembly are correct, but when it rolls up by customer, it should be the aggregate sum of the backlog for all assemblies. 

How can I set this up differently so that I can see the backlog by customer and assembly? Let me know if more detail is needed to solve this. 

[v-zhangti · Accepted solution]

Hi, @amirel01 

You can try the following methods.

Result Measure = SUMX('Table',[Backlog])

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

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

[amirel01]

That worked. Thank you so much!