Calculate Fiscal Sales Last Year with subtotals

[Tuan]

I'm trying to calculate last year sales on a Fiscal Calendar from the weeks level up to the quarter level. 

I used this code for Previous Year Sales. My problem is that I don't get the Subtotals for Monthly and Quarterly. My calendar itself does have a unique code that gives me year and week such as 20191 for 2019 week 1.

Previous Year Sales = 
VAR CurrentWeek = SELECTEDVALUE( VW_ROSSDW_DIM_DATE[fin_week_in_year] )
VAR CurrentYear = SELECTEDVALUE( VW_ROSSDW_DIM_DATE[fin_year])

RETURN
CALCULATE( [Demand $],
    FILTER( all(VW_ROSSDW_DIM_DATE),
		 VW_ROSSDW_DIM_DATE[fin_week_in_year]= CurrentWeek && VW_ROSSDW_DIM_DATE[fin_year] = CurrentYear - 1))

[v-chuncz-msft]

@Tuan 

You may take a look at the posts below.

• https://community.powerbi.com/t5/Desktop/Hide-matrix-rows-without-affecting-values/m-p/646134#M30968...
• https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M...

[Tuan]

That doesn't really solve my problem. I do have a Year/Week column in my date Dimension that says 201901, 201902, etc.

Been trying to get this code to work. The minus 100 is to offset the year to 201801, 201802, etc. It not working.

VAR CurrentWeek = SELECTEDVALUE( VW_ROSSDW_DIM_DATE[fin_week_in_year] )
VAR CurrentYear = SELECTEDVALUE( VW_ROSSDW_DIM_DATE[fin_year])

RETURN
CALCULATE( [Demand $],
    FILTER( VW_ROSSDW_DIM_DATE,
		 VW_ROSSDW_DIM_DATE[fin_year_week]-100))