Forum Discussion
HenryJS
6 years agoPost Prodigy
Matrix: Measure Totals Incorrect
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 thi...
- 6 years ago
Try like
sumx(summarize(Table,Table[PlacementRec..],Table[CompanyHQ],table[Company Name], Table[Cadidate name],"_1",[Timesheet]),[_1])
Change group by as per need
amitchandak
6 years agoSuper User
Try like
sumx(summarize(Table,Table[PlacementRec..],Table[CompanyHQ],table[Company Name], Table[Cadidate name],"_1",[Timesheet]),[_1])
Change group by as per need