Forum Discussion
Count Completion Item Per Month
I have created a calendar auto table and trying to do a stacked chart to show open vs closed items per month. I could not return the count completed item per month? CountClosedItemPerMonth = ...
Anonymous wrote:
Sorry, I got one problem. it is showing a high value of the blank completion item. How do I resolve it?
I'm not sure what you mean by "high value" - are you possibly saying you do not want to count rows with no completion date? If so you could just add this condition to the calculate expression.
eg.
CountClosedItemPerMonth =
CALCULATE(countrows(TABLE),
NOT( ISBLANK( TABLE[Completion Date] ) )
USERELATIONSHIP(TABLE[Completion Date],'Date'[Date])
)
Hi,
Share some data and show the expected result.