Formula not working without adding the year on the visual

Its not wirking as you are using Selected value. So if there is no year column, the selected value is blank. Insted selected value, you may try max of date. Is also not showing the total as at total level your conditions doesnot matches. 

Hi, andicornejo12 

You can try the following formula.

PY CW =
VAR _selectedYear =
    MAX ( 'Date'[Year] )
VAR _selectedWeek =
    MAX ( 'Date'[Week] )
RETURN
    IF (
        NOT ISINSCOPE ( 'Date'[Week] ),
        CALCULATE (
            SUM ( Orders[Sales] ),
            FILTER ( ALL ( 'Date' ), 'Date'[Year] = _selectedYear - 1 )
        ),
        CALCULATE (
            SUM ( Orders[Sales] ),
            FILTER (
                ALL ( 'Date' ),
                'Date'[Year] = _selectedYear - 1
                    && 'Date'[Week] = _selectedWeek
            )
        )
    )

If this does not solve your problem, please provide more information about the data.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.