Forum Discussion

Hsilva's avatar
Hsilva
Icon for Helper I rankHelper I
6 years ago
Solved

Power Pivot Grand Totals

  Hi, I understand that one solution for the grand totals error is to use the SUMX function. The problem is I do not know how to write the function when I am working with multiples table and measure...
  • Hsilva's avatar
    Hsilva
    6 years ago

    Thank you very much UlfBergqvist.

    Yes, you are right the problem is the grand totals. Just one more question, in the NewMeasure below, the table "Project" in the Sumx formula, is a new one or an existing one?

     

    Thanks

    Hsilva  

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi, this is starting to get a little bit complicated. But since the calculateion is ok on FN 15 and FN 16, my best guess right now is to add the FN table to the crossjoin as well to do the calculation by project/employee and FN.

     

    / Ulf

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, this is starting to get a little bit complicated. But since the calculateion is ok on FN 15 and FN 16, my best guess right now is to add the FN table to the crossjoin as well to do the calculation by project/employee and FN.

 

/ Ulf

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You could also try to replace the CROSSJOIN with SUMMARIZECOLUMNS(Staff[Emp ID], Projects[id], Calendar[FN]).