Forum Discussion
Helper IHelp needed with Recursive / Iterative Calculation
Apologies for the delayed response, I have found the solution to my query here:
https://community.powerbi.com/t5/Desktop/Cumulative-backlog-to-date/td-p/35469
Thanks for your time and I really appreciate you looking into this for me.
Resolver IHi asah ,
Perhaps the following measure:
OpenTicketCount = Calculate(Distinctcount([Ticket Id]), [IsBreached] = "True")
And if you slice that by date in a table visual for example, it should give you the desired result. That's if I've fully understood your requirement of course.
- ImkeF
Community Champion
Hi asah
not sure about your requirement here. With regards to the first row: Do you want to count this item as open at the date of 31. January of example? So basically create a history of open/closed status?
asahHi ImkeF
Thanks for looking into this. Apologies, I noticed that I did not sort the sample data before uploading. It should be sorted first on the created date and then the ticket id. Regardless of that, this is what I am trying to achieve in a column:
1) Considering that ticket created on 30-Jan is the first ticket in the source data, the backlog of open tickets out of SLA will be 0
2) 2nd row suggests that a ticket has been created on 4-Feb, however the previous ticket has been closed on 3-Feb, so the backlog of open tickets out of SLA remain 0.
3) Again, there is another ticket opened on 4-Feb and the previous ticket still remains open and IsSLABreach = False, so the backlog still remains 0. However, if the IsSLABreach had been True, the value would have been 1.
So on and so forth. Please let me know if I am making sense or I will try and explain differently. Any help is greatly appreciated.
Cheers,
Anirudh
