Hi,I’m working on a dump/damaged report. It’s by item with multiple amount columns. One for sales for the item, and one for the amount dumped or damaged. That part is easy. The tricky part is I only want to show items that have a dump on them. So basically filter the dumped column to exlude all zero amounts.But I can’t figure out how to do that. Any ideas?Thanks,

answer that worked for me IF( Qty Dump = 0, BLANK(), SUM( Qty Sold) )

Filter items that have dump/damaged as reason code (while still including sales)

dedelman_clng
Community Champion
7 years ago
Use this type of FILTER statement in your measures:

FILTER(ProductTable, ProductTable[Dumped] <> 0)
If it's more complex than that, please share some sample data and sample outcome.

Hope this helps
David
- Anonymous
  Not applicable
  7 years ago
  When I do that I I get zero results. Basically it only is summing up each invoice that has a dump amount on it. When what I want is the total amount of sales of that item number if any of that item number has a dump.
  Programically it would be something like
  If ITEM has dump qty > 0 then sum sales for that item
  Do I need to do something with an ALL statement?
  
  Here is the measure I tried
  Sales = CALCULATE(sum('Item Value New'[Net Sales]), FILTER('Item Value New','Item Value New'[Reason]= "Sales"),FILTER('Item Value New','_Dump Measures'[Dump Qty] > 0))
  - Anonymous
    Not applicable
    7 years ago
    answer that worked for me
    
    IF( Qty Dump = 0, BLANK(), SUM( Qty Sold) )
Scott-Munch
New Member
7 years ago
Could you use a page level filter and just filter on values that have a "dump" assigned to them?