Filter a DAX measure with dynamic date filters / Time Intelligence
I need to filter a calculated table to find the metric for a particular department of goods and a dynamic date range. The Sales Cycle should have a Sold % Quantity which is the total items sold divided by the number of items produced. These two numbers need to match: This DAX is not working: Sold % Qty Clothing = VAR _startSalesCycle = DATE(2024, 02, 04) VAR _endSalesCycle = DATE(2024, 02, 27) CALCULATE( [Sold % Qty], 'Production Units by Week'[DepartmentName] = "Donated Clothing", DATESINPERIOD(Dates[Date], _startSalesCycle, _endSalesCycle, DAY ) ) Eventually, I want the start and end of the Sales Cycle to determine how this table gets filtered on a weekly basis. Which date filters should I use?
