Filtering report by date and sum of quantity

[ahhollan]

I have an excel ssheet that is connected to Power BI.  It has individual overtime entries for employees. Overtime hours for a given day are in the column called 'Quantity'.  When I create a bar chart report and filter to data within a given date, I also want to filter on the sum of the quantity for the selected dates for an employee.  Adding Quantity as a filter only filters on the individual rows. How do I set this up so that the quantity filter is based on the sum of the records for the employee?  When I set the field as a sum, the values on each bar are the sum of the records for that employee, but the filter still only filters individual records.

[parry2k]

@ahhollan create a measure for sum of quantity and use this measure in visual level filter

[ahhollan]

Here is the formula I used 

SumQty = SUM(Page1[Qty])

It's still filtering on quantity and not the sum. I get no results returned when I set min and max numbers on sum filter.

[dax]

Hi ahhollan, 

If possible, could you please inform me more detailed information (such as your sample data and your expected output)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.