Forum Discussion

NadiaHap's avatar
NadiaHap
Frequent Visitor
3 years ago
Solved

column sum incorrect

Hello everyone! I'm having a problem with the column sum being calculated incorrectly. I need to find value 2 (J2), formula =1/SUM(G2:G4)/(1+I2)-1   But for this, need to correctly calculat...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

MFelix's avatar
MFelix
Super User
3 years ago

Hi NadiaHap ,

 

Looking into the numbers something is not matching because the discount of -5% is not 10.005 if you do 0.5% 

 

Are you abble to share the excel file where you have the calculations?

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    Hi NadiaHap ,

     

    I have looked at your file and believe that you need to create the following measures:

     

    Budget without discount =
SUMX ( 'Table', DIVIDE ( [Budget], ( 1 + 'Table'[discount 1] ) ) )value 2 =
VAR temptable =
    SUMMARIZE (
        'Table',
        'Table'[ Month],
        'Table'[ budget sum],
        'Table'[discount 1],
        'Table'[discount 3],
        "%BUd", [% Budget]
    )
RETURN
    SUMX (
        temptable,
        1
            - DIVIDE (
                DIVIDE ( [%BUd], ( 'Table'[discount 3] + 1 ) ),
                ( 1 + 'Table'[discount 1] )
            )
    )

Final Value = 
DIVIDE(DIVIDE(1, [value 2]), (1+ [value 1]) )-1

     

    The other metrics are ok.

    See PBIX file attach.