Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

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...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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