Cumulative removal and addidtion with Month on Month

[poojashribanger]

Hello All,

I am trying to show count of ID in bar chart month wise where i need to show or remove ID based on condition and month.

If the status of an ID is closed or exported then we need to remove those ID's completely from chart month-on-month basis.

for example if month Apr is selected then this ID will appear in Apr Month but if month Apr and May both selected then this ID should not appear in chart as the status is closed in APR month.

ID	status	dateTimestamp	Month	Year
70	draft	05-04-2023 10:12	Apr	2023
70	draft	05-04-2023 12:39	Apr	2023
70	ready	05-04-2023 10:12	Apr	2023
70	ready	05-04-2023 13:53	Apr	2023
70	draft	13-04-2023 10:39	Apr	2023
70	rejected	13-04-2023 10:39	Apr	2023
70	ready	25-04-2023 09:25	Apr	2023
70	draft	28-04-2023 07:15	Apr	2023
70	ready	01-05-2023 11:21	May	2023
70	draft	02-05-2023 09:28	May	2023
70	ready	02-05-2023 13:11	May	2023
70	rejected	05-05-2023 08:36	May	2023
70	draft	30-05-2023 12:45	May	2023
70	ready	30-05-2023 12:48	May	2023
70	closed	31-05-2023 11:51	May	2023
70	closed	31-05-2023 12:22	May	2023
70	exported	31-05-2023 12:22	May	2023

thanks & regards,

Poojashri

[amitchandak · Accepted solution]

@poojashribanger , Try this measure in visual or visual level filter

New measure =
var _tab = Summarize(filter(allselected(Table),Table[Status] ="closed"), table[ID])
return
countrows(filter(Table, Not Table[id] in _tab))

[poojashribanger]

Thank You so much for this.

I have been struggling for this for days.

It's working