Forum Discussion

bobbyd's avatar
bobbyd
Frequent Visitor
2 years ago
Solved

Using Disconnected Table and total line not correct

I have a disconnected table and using the following logic to compute total sales per FY week (current FY and compared to last FY).

 

Total Net Sales FY Week =
VAR _item = MAX('All FY Sun-Sat Week End Dates'[Fiscal Sun-Sat Week End Date])
RETURN CALCULATE([Total Net Sales], FILTER('Activity Date','Activity Date'[Fiscal Sun-Sat Week End Date] = _item))
 
Total Net Sales Last FY Week =
VAR _item = MAX('All FY Sun-Sat Week End Dates'[Previous FY Sun-Sat Week Thru Date])
RETURN CALCULATE([Total Net Sales], FILTER('Activity Date','Activity Date'[Fiscal Sun-Sat Week End Date] = _item))
 
My visual has a slicer for FY, and then the matrix lists each week in the FY with sales for each week from current fy compared to last fy week numbers.
 
The total line just is a copy of the last fy week end date. I understand why due to my logic, but I cant figure out how to change the logic for the total line to be a sum of each individual week totals and still keep each individual week numbers correct.
 
Bob

1 Reply