SSAS CUBE in EXCEL - Grand total does not SUM correct RRS feed

  • Question

  • Hi,

    I have a problem with grand total values when browsing a SSAS cube data through excel.

    Grand total does not SUM all values.

    When I browse cube and same data through Power BI it SUM it correct.

    Al ok when browsing a same data through SSMS:

    Data from the source table:

    If anyone knows what is the problem or if anyone have some kind of explanation.... I would be grateful!!

    Thursday, March 7, 2019 2:59 PM