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

[Anonymous]

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,

[Scott-Munch]

Could you use a page level filter and just filter on values that have a "dump" assigned to them?

[dedelman_clng]

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]

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 · Accepted solution]

answer that worked for me

IF( Qty Dump = 0, BLANK(), SUM( Qty Sold) )