How to include closed items in the stacked column chart?

Hi jbrolland ，

Please correct me if I wrongly understood your question.

For STATUS=”DONE” ,there are two dates , one is Opened Year and Month and other is Closed Year and Month . So if you use different date to count ,you will get different results . If you put different dates and different status in the same visual, the displayed results will be more complicated .My suggestion is creating two visuals to display the counts of two dates .

I create measures to count different status .

ONGING = CALCULATE( COUNTA('Table'[STATUS]),FILTER('Table','Table'[STATUS]="ONGOING" ))

NOT FIXED = CALCULATE( COUNTA('Table'[STATUS]),FILTER('Table', 'Table'[STATUS]="NOT FIXED"))

DONE = CALCULATE( COUNTA('Table'[STATUS]),FILTER('Table','Table'[STATUS]="DONE"))

Then create two clustered column chart visuals ,like this

Best Regards

Community Support Team _ Ailsa Tao

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