eliminate items that have too many blank entries

[notalex]

Hello everyone,

I am trying to eliminate "items" that have not been sold enough times in the year per a week basis.
Thus, I would need to some the total quantity sold in a year of that item. Then I would eliminate the item that was not sold enough.

i.e. I only want items that were sold more than 20 times. Only 13 hamburgers were sold, thus I want to eliminate them. However, 34 pizzas were sold thus I want to keep them.

Thanks in advance for the help!

Week number	quantity sold	item title
1	5	hamburger
2	0	hamburger
3	7	hamburger
4	1	hamburger
1	20	pizza
2	6	pizza
3	7	pizza
4	1	pizza

[ValtteriN]

Hi,

One of the more straight-forward ways of doign this is to create a filter measure e.g.

Filter if less than 20 = IF(CALCULATE(SUM('Table (25)'[quantity sold]),ALL('Table (25)'[Week number ]))>=20,1,0)

Then place it as a filter like this:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[ManguilibeKAO]

Hi,

If t is your table, the filtered table is

Filter(t,[Quantity] >20).

Best regards.