Reply
notalex
Frequent Visitor

eliminate items that have too many blank entries

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 solditem title
15hamburger
20hamburger
37hamburger
41hamburger
120pizza
26pizza
37pizza
41pizza

 

2 REPLIES 2
ValtteriN
Super User
Super User

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:
ValtteriN_0-1677083812116.png



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/








Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ManguilibeKAO
Resolver I
Resolver I

Hi,

 

If t is your table, the filtered table is

 

Filter(t,[Quantity] >20).

 

Best regards.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)