How to calcul the sum on fild filtred by two dates slicers
I have the tables : Reference_products wich contains fields : Ref_product libelle, produit product_history wich contains columns : ref_product_hist, ref_product, start_date_history and end_date_history and number_product_available dimDateStart dimDateEnd the table product_history table is linked to 2 calendar tables: dimDateStart through the start_history_date field dimDateEnd through the end_history_date field I need to have in my report 2 date slicers : the first one to choise a start date and another to choise an end date and I need to have a mesure wich calculate the sum of the number_product_available field in the table start_history_date where : start_history_date > selected date from the first slicer date (dimDateStart) and end_history_date < selected date from the end date slicer (dimDateEnd) there is my model : NB: I just start learning dax and I have no idea how I could do it, I thank you for any help you will find my source file and my pbix in this link : https://we.tl/t-phCWQvx889 I thank you again
