Data from previous years not appearing when filtering

Hello Kacper3,

Can you please try this:

06 - Total Win = 
CALCULATE(
    COUNTROWS('result_deals'),
    'result_deals'[dealstage] = "Closed - Won"
)

20 - Total_QS = 
CALCULATE(
    COUNTROWS('result_deals'),
    OR(
        NOT(ISBLANK('result_deals'[original_quote_date])),
        'result_deals'[dealstage] = "Quote Submitted"
    )
)

03 - ConversionRate = 
DIVIDE(
    CALCULATE(
        [06 - Total Win],
        'result_deals'[CloseYear] = SELECTEDVALUE('Calendar'[Year])
    ),
    CALCULATE(
        [20 - Total_QS],
        'result_deals'[QuoteYear] = SELECTEDVALUE('Calendar'[Year])
    )
)

QuoteYear = YEAR('result_deals'[original_quote_date])

CloseYear = YEAR('result_deals'[close_date])

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

Hi Kacper3 

While measures can contain aggregates outside the selected range, the way filters from a related or the same table work is that it shows only the rows based on what's been selected such that if you select 2024, it will show just all 2024rows. You can either change the numeric slicer to before and reference the max year in your measure or use a disconnected table to show even those that are not from the current year using still by referencing it in a measure.

Sahir_Maharaj danextian Ashish_Mathur 

I've tried both solutions but they still don't seem to work. 

I've tried creating a centralized date table and making the active relationship to original quote date but it's still not working. 

Due to data privacy and working with real information, below is sample of my data (it's not allowing me upload a CSV file) 

I have highlighted project 12 an example. 

The goal is to create a conversion rate of quotes submitted to projects won. Then, in a line graph display and card visual show the total projects won and projects quoted. Finally, use a date slicer to narrow down and see the total project won and quoted in a set period (Year, QTR, and Month)