Forum Discussion

motyagi's avatar
motyagi
Icon for Helper I rankHelper I
8 years ago
Solved

Grand Total In power BI matrix doesn't match

Hi There, 

 

I have a Table and the grand totals for a measure dont match up. i.e If I add each row in the table in excel it doesn't give me the same result as Power BI. 

 

How can i fix this ? Please Help !!!

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    motyagi

     

    Hi, try with this measure:

     

    Result-CostExpectation =
IF (
    HASONEVALUE ( Table1[Project ] );
    [CostExpectationM];
    SUMX ( VALUES ( Table1[Project ] ); [CostExpectationM] )
)

    Regards

    Victor

8 Replies

    • motyagi's avatar
      motyagi
      Icon for Helper I rankHelper I
      8 years ago
      Project NI PY Total PYNI % I CY Cost Expectation 
      A16302417437123767943.91%104112029185628247.3
      B4231099711587985436.51%3679047457949449.39
      C2139526613846731915.45%4847409357332877.72
      D390563314003412.44%13747351570016.429
      Total22712100062872488636.12%190751331298627859.5

       

      Cost Expectation  = ICY/(1-NI %) 

      The grand total is performing this at the grand total level row I just need it to add it for all the Projects so the sum is 302480591. 

       

      Thanks

      • sqlguru448's avatar
        sqlguru448
        Icon for Helper III rankHelper III
        8 years ago

        I am not sure what exact relationship you have in your modeling, but when I tried to populate and apply the formula for cost expectation. I was able to see the correct Grand Total.

         

        Screenshot Above.