Forum Discussion

misul's avatar
misul
Icon for Helper I rankHelper I
8 years ago

How is the grand total calculated?

Hello!

 

I have a .odc file, downloaded from PBI after clicking on Analyse in Excel. I created a normal pivot table in this Excel file and there is a "Grand Total" calculated based off of Years. 

 

Is there a way to check what kind of formula is used to calculate the Grand Total? It is not the sum or the average or averagea ... I have tried those.

Need Help

1 Reply

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    8 years ago

    it's the exact same formula in DAX, the only difference is filter context - multiple years
    if you have some syntax modifying Year evaluation context (e.g. hardcoded year filter) it may cause the Total to look funny
    can you share the DAX for the measure in question?