QTY based on the date range

hi Ania26 

I added more rows to your sample table.

First, create a separate dates/calendar table and create a one to many single direction relationship from that to your fact table joining on their respective date columns.

Create either of these measures that modify the filter context on DatesTable:

Qty 2023-2024 = 
//total qty for 2023-24 regardless of the date range selected
CALCULATE (
    SUM ( 'DataTable'[QTY] ),
    FILTER ( ALL ( DatesTable ), DatesTable[Year] IN { 2023, 2024 } )
)


Qty All Dates = 
//total qty for all dates regardless of date range selected
CALCULATE ( SUM ( 'DataTable'[QTY] ), ALL ( 'DatesTable' ) )

Create another measure that responds to the date slicer selection:

Qty Selected Dates = 
SUM ( 'DataTable'[QTY] )

Use the date column from the dates table and the fruit column from your fact table and the measures

Please see attached sample pbix.