topic Re: Backlog report by sub-categories and category in DAX Commands and Tips

Backlog report by sub-categories and category

amirel01 — Wed, 29 Nov 2023 20:46:27 GMT

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.

Re: Backlog report by sub-categories and category

v-zhangti — Fri, 01 Dec 2023 08:39:04 GMT

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.

Re: Backlog report by sub-categories and category

amirel01 — Mon, 04 Dec 2023 13:17:47 GMT

That worked. Thank you so much!