how to filter LOOKUPVALUE

[Anonymous]

I have a table like the following:

Week Key	Week Label	Year
2019.1	a	2019
2020.2	b	2020
2021.1	a	2021

I have a line chart with [Week Label] (**not [Week Key]**) on the x-axis.  I want to return the cumulative sum of some numerical column in my fact table for [Year] = 2020.  How can I do so?  I have tried the following, but DAX is saying that, for the LOOKUPVALUE portion of the code, "a table of multiple values was supplied where a single value was expected."  So, I must not be filtering 'Dimension Week' correctly in the LOOKUPVALUE portion of the code.

Cumulative Sum of Sales - 2020 =
VAR __given_week =
    MAX('Dimension Week'[Week])

VAR __corresponding_week_key =
    CALCULATE(
        LOOKUPVALUE(
            'Dimension Week'[Week Key]
            ,'Dimension Week'[Week]
            ,__given_week
        )
        ,'Dimension Week'[Year] = "2020"
    )

RETURN
    CALCULATE(
        [Sum of Sales - Year 2020]
        ,ALLEXCEPT(
            'Dimension Week'
            ,Dimension Week'[Year]
        )
        ,'Dimension Week'[Week Key] <= __corresponding_week_key 
    )

[Anonymous]

I think I solved my problem.  I was misunderstanding the syntax for LOOKUPVALUE.

VAR __week_key =

    LOOKUPVALUE(

        'Dimension Week'[Week Key]

        ,'Dimension Week'[Week]

        ,__max_week

        ,'Dimension Week'[Fiscal Year Relative Category]

        ,"FY-2"

)

[V-lianl-msft]

Thanks for your update. As the issue is resolved. I will close this thread.