Forum Discussion

sabd80's avatar
sabd80
Helper IV
2 years ago

Wrong total

Hi,
I have below Forecast measure, it gives the wrong total, in the total it ignores the values of Actual:

Forecast =
SUMX(  
    VALUES('Calendar'[Month]),IF(ISBLANK([Forecast 0-11]), [Actual], [Forecast 0-11])
)
The wrong total is adding = 3,377,109.42 + 154,585.55+1,359.00 = 3,533,053.97
The correct total should be = 25.80 + 3,377,109.42 + 154,585.55+1,359.00 + 172.35= 3,533,252.17
 
 
I am not sure why this is happenning.
Any idea?
Need Help

4 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    maybe you can try to separate the dax

    FC=IF(ISBLANK([Forecast 0-11]), [Actual], [Forecast 0-11])

    forcast=

    SUMX(  
        VALUES('Calendar'[Month]),FC
    )
      • ryan_mayu's avatar
        ryan_mayu
        Super User
        2 years ago

        maybe you can try 

         

        sumx(values(category),xxx)

         

        if still does not work ,pls provide the pbix file to have a further investigation. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi sabd80 ,

     

    You can create a calculated column:

    Column = IF([Forecase 0-11]<>BLANK(),[Forecase 0-11],[Actual])

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.