Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculated measure that won't sum

Hi,   I have a question about a calculated measure that won't sum in a table.    The measure is    FreightCost Forecast = if(sum(transportorder[freightcost])=0;calculate(transportorder[Freight...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

Sure, here you go.

FreightCostLY = 
CALCULATE(
    [FreightCost],
    SAMEPERIODLASTYEAR(Dates[Date])
)
FreightCostForcast = 
VAR FutureMonths = FILTER ( VALUES ( Dates[Date (bins)] ) , [FreightCost] = 0 )
RETURN 
SUMX(
    FutureMonths,
    [FreightCostLY] * .8
)

 

AN_PBI's avatar
AN_PBI
Frequent Visitor
6 years ago

Thanks a lot