Matrix: Measure Totals Incorrect

[HenryJS]

Hi all,

I have a matrix with the Values including a measure (measure posted below).

The totals are not showing correctly? Both the subtotals of each row and the bottom grand total.

Is this because of the measure?

Timesheet? = maxx(FILTER('Export Placements','Export Placements'[PlacementStartDate]<=max('Date'[Date]) && (ISBLANK('Export Placements'[PlacementEndDate]) || 'Export Placements'[PlacementEndDate] <=max('Date'[Date]))),'Sheet1'[Timesheet Value])

Cheers 

Henry

[v-shex-msft]

HI @HenryJS,

I'd like to suggest you can take a look at below blog that shares from @Greg_Deckler, it clearly mentioned the measure total calculation issue and how to fix it:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@HenryJS 

Try like

sumx(summarize(Table,Table[PlacementRec..],Table[CompanyHQ],table[Company Name], Table[Cadidate name],"_1",[Timesheet]),[_1])

Change group by as per need