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 ,

 

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.