Forum Discussion

sabd80's avatar
sabd80
Helper IV
2 years ago
Solved

Wrong total

Hi,

I have a new measure that gives the wrong total.

 

New Measure =IF(ISBLANK([Forecast]), [Actual], [Forecast])

But the total of the New Measure is giving only the last month (12, August).

 


how can I get the correct total?


I can't provide the data because it is connected to a model.

 

Need Help
  • darkinvader_'s avatar
    darkinvader_
    2 years ago

    Hi sabd80 

     

    first we need to understand is that it is not giving you last month august total it is giving you total of [Forecast], because in that context the [Forecast] is not blank and as per your measure's IF condition we're getting that value of Forecast Total. To resolve this issue you can use this modified version of your code

    New Measure=

    SUMX(
        VALUES('Calendar'[Date].[Month]),// in your case the Month column from your dataset
        IF(ISBLANK([Forecast]), [Actual], [Forecast])
    )


    If this helps do give a thumbs up and accep this as a solution

    BR
    Dark

2 Replies

  • darkinvader_'s avatar
    darkinvader_
    Resolver I
    2 years ago

    Hi sabd80 

     

    first we need to understand is that it is not giving you last month august total it is giving you total of [Forecast], because in that context the [Forecast] is not blank and as per your measure's IF condition we're getting that value of Forecast Total. To resolve this issue you can use this modified version of your code

    New Measure=

    SUMX(
        VALUES('Calendar'[Date].[Month]),// in your case the Month column from your dataset
        IF(ISBLANK([Forecast]), [Actual], [Forecast])
    )


    If this helps do give a thumbs up and accep this as a solution

    BR
    Dark