I have a sales report with sales numbers that shows all the sales from multiple vendors for 2022. I would like to create a report that shows me the percentage of total sales from only 2 specific vendors from a date range. I created a matrix table where I filtered my two vendors I want to look at. I have the 2022 total sales of those two vendors in one column and I created another measure to show total sales of All the vendors, so that I can divide the two to get me the % of total sales for those two vendors. The matrix I created shows me % of sales for all of 2022. Now I would like to do this same thing, but from a specific date range like the week of April 18-24. I would need the total sales of that week for those two vendors and the total sales of All the vendors for that week so i can find the percentage of total sales. Is that possible? Is there a dax for this?