Total Wrong

[VincenzoChean]

Hi, 

i'm not sure why the Budget Total is showing the Total for the full year including the months that have not started when my measure is supposed to ignore the months that have no Actual numbers. 

the measures are 

Total Sales =

CALCULATE(

    sum('IWL Append'[Total Revenue]))

Sales Budget =

IF(ISBLANK([sum total revenue]),BLANK(),sumx(SalesBudget,SalesBudget[Value]))

Var Budget =

VAR __BASELINE_VALUE = SalesBudget[Sales Budget]

VAR __VALUE_TO_COMPARE = [Total Sales]

RETURN

    IF(

        NOT ISBLANK(__VALUE_TO_COMPARE),

        DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

    )

[amitchandak · Accepted solution]

@VincenzoChean , This is because of the row context , push column from visual

Sales Budget =

Sumx(Values(Date[Month]) , calculate( IF(ISBLANK([sum total revenue]),BLANK(),sum(SalesBudget[Value])) ) )

[VincenzoChean]

thanks mate. it worked now. cheers