Prior week Sales change measure not working

[Anonymous]

I apologize if this has already been answered.  I could not find a similar issue or resolution.

I am running the March 2017 release of Powerbi Desktop.

We have a custom date calendar.  To that end, I have created a separate date table (Fiscal_Calendar_Daily) , one row for each date. I also have a column in this table called week ending date which has the last day of the fiscal week.

I have built some prior week sales measure(s) and they work perfectly in a table in Powerbi.  Here is the calc for prior week

Total Net Sales PW = CALCULATE([Total Net Sales], FILTER(ALL(Fiscal_Calendar_Daily[WeekEndingDate]), Fiscal_Calendar_Daily[WeekEndingDate] = max(Fiscal_Calendar_Daily[WeekEndingDate])-7))

When I try to do a % change calc referencing this measure, it comes back null.    When I simply pull in this measure to a table visualization , it works perfectly. I have filters (slicers) to select the appropriate fiscal year and fiscal week.

I have never had this situation where a measure could not be referenced into another measure.  I must have something wrong, but not sure what the issue is.

Thanks very much.

Pete

[v-qiuyu-msft]

Hi @Anonymous,

>>When I try to do a % change calc referencing this measure, it comes back null.   

How did you to reference this measure and which visual did you use to display that %change? Please share some sample data and desired results to clarify the issue.

Best Regards,
Qiuyun Yu

>>>.......ccv>>..