Table to Filter Out Items Without Transactions

[Anonymous]

The goal is to have a table which will remove items that have not had transactions over 3 weeks. Currently, I have a table which highlights weekly transactions of items >>> Current week vs. Previous week. There can be items which will have no transactions. Problem is that there are hundreds of items and my current table can have an vast amount of items that have not recorded any transactions. Although my current output provides all of the information needed, visually it is not appealing with so many items/rows reflected without any transactions. I am aware that I can filter the rows to reflect Transaction_Count > 0. But not sure how to put another condition that flags 0 transactions over 3 weeks.

Is it possible to filter out items (and/or rows) which have not recorded any transactions over 3 weeks ? Your advice is greatly appreciated. 

Current Output: Please note Item_Code: A1 / A5 >>> A1 + A5 have not recorded any transactions over the past 3 weeks. 

Item_Code	Fiscal_Week_Year	FW_StartOfWeek	Transaction_Count	Prev_Week_Count
A1	FW16-2022	Monday, December 13, 2021	0	0
A2	FW16-2022	Monday, December 13, 2021	0	12
A3	FW16-2022	Monday, December 13, 2021	50	0
A4	FW16-2022	Monday, December 13, 2021	3	12
A5	FW16-2022	Monday, December 13, 2021	0	0
A1	FW15-2022	Monday, December 06, 2021	0	0
A2	FW15-2022	Monday, December 06, 2021	12	3
A3	FW15-2022	Monday, December 06, 2021	0	0
A4	FW15-2022	Monday, December 06, 2021	12	0
A5	FW15-2022	Monday, December 06, 2021	0	0
A1	FW14-2022	Monday, November 29, 2021	0	0
A2	FW14-2022	Monday, November 29, 2021	3	11
A3	FW14-2022	Monday, November 29, 2021	0	9
A4	FW14-2022	Monday, November 29, 2021	0	21
A5	FW14-2022	Monday, November 29, 2021	0	1

Expected Output: Please note Item_Code: A1 / A5 >>> A1 + A5 have been removed because there no transactions recorded. 

Item_Code	Fiscal_Week_Year	FW_StartOfWeek	Transaction_Count	Prev_Week_Count
A2	FW16-2022	Monday, December 13, 2021	0	12
A3	FW16-2022	Monday, December 13, 2021	50	0
A4	FW16-2022	Monday, December 13, 2021	3	12
A2	FW15-2022	Monday, December 06, 2021	12	3
A3	FW15-2022	Monday, December 06, 2021	0	0
A4	FW15-2022	Monday, December 06, 2021	12	0
A2	FW14-2022	Monday, November 29, 2021	3	11
A3	FW14-2022	Monday, November 29, 2021	0	9
A4	FW14-2022	Monday, November 29, 2021	0	21
A5	FW14-2022	Monday, November 29, 2021	0	1

[amitchandak · Accepted solution]

@Anonymous , create   a measure for 3 weeks and use that in visual level flter check >0 and noy is blank

Rolling 3 week = CALCULATE(sum(Table[Transaction_Count]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-21,Day))

in visual lvele filter check Rolling 3 week  >0 and Rolling 3 week  is not blank

[Anonymous]

@amitchandak thank you so much for your support! This worked great! So much gratitude!