Forum Discussion
Subsets with measures
I want to calcualte only sum Shipment Quantity when there was a return. Customer Shipment Quantity Return Quantity Return % A 50 35 70% B 100 5 5% C 340 0 0%...
Not sure if there is a record for the most back and forths, but, since the returns and sales are on different rows, we need some way to filter out the sales rows that have >0 returns. You did that in the visual with a filter on the Returns measure, and I tried to do that with the FILTER(ALLSELECTED( ) on Product Brand (to replicate what you did in the visual). What else do the rows have in common? Is there a parent sale ID or something that associates them?
Signing off soon for the night. I will pick it up tomorrow, if someone else doesn't give a solution first.
Regards,
Pat