I am needing some help to get 2 sums then the difference of them afterwards.
Firstly, i need to sum if the month is Jan and status open, Feb and status Open, March and status Open all the way thru December.
Secondly, i need to sum if the month is Jan and status closed, Feb and status closed, March and status closed all the way thru December.
Finally, I need to find the net difference from Jan open and closed status to February open and closed status contnuing all the way thru december in this manner to create a trend in my graph.
I can send my pbix file to show what i have. I am able to count based on month and status of closed using this formula
columnclosedsum = Calculate(COUNTROWS('Table'),'Table'[Status]="close")
however, when i try to replicate that for another column for open items i get an error "<pi>A circular dependency was detected: Table[Column], Table[ClosedSumCol], Table[Column].</pi>"
Here is my data and an example screenshot of what i am expecting with a graph to help visulaze what i am trying to describe. I have the count working as previously mentioned for closed items and get a result of "1" in the closed sum column as expected if any month item has a status of open. I am expceting the same result in the open sum column however, it is giving me the error mentioned.
Once the open items are sumed.....then taking the net difference from open to closed per month (i.e. jan, jan-feb, etc) to use for a trend line.
PBIX file and Graph ex screenshot
