Using Disconnected Table and total line not correct

[bobbyd]

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

[Greg_Deckler · Accepted solution]

@bobbyd First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8