Yearly sales based on selection

^{Hi Prabha45 ,}

^{According to your description, you need to calculate the annual sales of the subcategories based on the selection of the slicer, and ignore the influence of the month.}

^{You can try this measure:}

SALES = CALCULATE(SUM(SALES[Amount]),FILTER(ALL(SALES),SALES[DATE].[Year] = MAX(SALES[Product].[Year])))

^{If this is not what you need, please provide sample data to address further.}

^{Best Regards,}

^{Gallen Luo}