trying to create a bar chart which includes counts of item as well as all item count

[MegaCleanCab]

We have a single table and I need to create a monthly chart which shows.  Total items opened vs Active vs closed.  I cannot do the count of the "total items opened" in the chart filter and still get the other status e.g. open vs closed.  I am thinking I need a calculated column but I am new at this and am having troubles.  Thanks

[v-yulgu-msft · Accepted solution]

Hi @MegaCleanCab,

Suppose source table is like below:

Then, you can create three measures similar to:

all items count = SUM('Monthly data'[Sales])

active items count = CALCULATE(SUM('Monthly data'[Sales]),FILTER('Monthly data','Monthly data'[Type]="Active"))

closed items count = CALCULATE(SUM('Monthly data'[Sales]),FILTER('Monthly data','Monthly data'[Type]="Closed"))

Best regards,

Yuliana Gu

[Ashish_Mathur]

Hi,

Share your source data.

[MegaCleanCab]

I cannot share the actual data as its confidential.  The source is vsts.  thanks

[MegaCleanCab]

I took some time and purged the data.  I left some of the columns from the table and changed the values.  Let me know if it works.  Also how do I upload?