Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Grand totals issue

  • 1.  Grand totals issue

    Posted 8 days ago
    Hi,

    I used PowerBi for a short time on SQL Server 2017 OLAP Cube.  My issue is that the grand total for a measure gives me negative amounts.  The total by row and by column are ok, but the grand total is always negative or in some way wrong.  I've changed the datatype to bigint, and my model is inherited from the database format.

    What can I do differently?

    Thanks.

    ------------------------------
    Julie Gagnon
    ------------------------------


  • 2.  RE: Grand totals issue

    Posted 8 days ago
    Is this a direct connection to a cube? What is the measure formula? a bit more information is needed.


    ------------------------------
    Ka Ly
    Clinical Informatics Program Manager
    ------------------------------



  • 3.  RE: Grand totals issue

    Posted 8 days ago
    It's a direct connection and the measure is not a formula by itself.  It's a value between 50K and 100K for each transaction.  I have about 100K transactions, which is a small cube.  The sum of this field is working fine for rows and columns with dicing perspectives.  It's the grand total who sums up negative

    ------------------------------
    Julie Gagnon
    ------------------------------