DAX Measure

Hi Everyone,

I am quite new to Power BI. I have cases table where I am looking for cases in last 14 days and 28 days respectively. I’ve created 2 measures, I am using ‘Case Date’ from the table to filter those cases which looks correct. But when I try to display this into a Power BI report table where I’ve added a column ‘Area’ total are showing the exact as the measure are showing, but in the table numbers are not quite adding up. I believe the measure are now calculating from the max case date associated from a particular area column. I don’t want to filter from today’s date I want this work when user select date range from slicer and it work dynamically. Thank you very much for your help.