Wrong total

[sabd80]

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.

[sabd80]

Thank you so much @darkinvader_, it worked.

[darkinvader_ · Accepted solution]

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