Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
answer that worked for me
IF( Qty Dump = 0, BLANK(), SUM( Qty Sold) )
Could you use a page level filter and just filter on values that have a "dump" assigned to them?
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
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))
answer that worked for me
IF( Qty Dump = 0, BLANK(), SUM( Qty Sold) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |