Create bar chart for gap between two count value per month

[Anonymous]

Hi,

I would like to make a bar chart showing the value of (count of closed - count of open) per month. Can you give me suggestion on how I put measure for this? Below table is the example of the data:

Notification	Date	Status
AAAA	04/01/2020	Closed
BBBB	02/04/2020	Closed
CCCC	18/06/2020	Open
DDDD	01/01/2020	Closed
EEEE	05/12/2020	Open
FFFF	06/01/2020	Closed
GGGG	07/08/2020	Closed
HHHH	08/08/2020	Open
IIII	09/08/2020	Open
JJJJ	10/08/2020	Open
KKKK	11/08/2020	Closed
LLLL	12/05/2020	Open
MMMM	13/11/2020	Closed
NNNN	15/03/2020	Closed

Thank you for your help.

Regards,

Vano

[Anonymous]

@Anonymous 

I have attached a simple. let me know if you have any questions.

Link: Bi File 

Thanks,

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

calculate(count(Table[Notification]), filter(Table, Table[Status]="Closed")) -calculate(count(Table[Notification]), filter(Table, Table[Status]="Open"))