Calculating previous year revenue across product categories

[AdamRobC]

Hi, I am trying to calculate last year revenue across product categories - the below DAX works for getting aggregated revenue for the previous year based on fiscal week, but just returns an aggregated total and does not split by category. Where am I going wrong?

LastYear Gross Revenue =

CALCULATE(

SUM(Range_data[Gross Revenue]),

FILTER(ALL(Range_data),

Range_data[Fiscal Year] = VALUES(Range_data[Fiscal Year]) - 1 && Range_data[Fiscal Week Number] = VALUES(Range_data[Fiscal Week Number])

)

)

[TomMartens · Accepted solution]

Hey,

I guess that this

FILTER(ALL(Range_data)

add to the confusion, as this also removes an axisting filter from your category column.

Maybe you can give this a try:

FILTER(ALLEXCEPT('Range_data' , 'Range_data'[<category column>]) ...

Hopefully this provides you with some ideas,

Regards,

Tom

[AdamRobC]

Thanks - that worked!