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

Hsilva's avatar
Hsilva
Icon for Helper I rankHelper I
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
Not applicable
6 years ago
It's the Projects table you have in your model. I trust you follow the golden rule of creating models: All fields in a fact table should be hidden from view. Only dimensions should be exposed.
  • Hsilva's avatar
    Hsilva
    Icon for Helper I rankHelper I
    6 years ago

    Thank you darlove for clarifying the table, and for your advice about hiding field in fact table. I will follow it.

    Cheers

    Hsilva