Forum Discussion
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...
Good morning Anonymous
I can, yes.
Updated PBIX file available here: https://www.dropbox.com/s/eu9rx5206hqpddo/FreightForcast.pbix?dl=0
jdbuchanan71
Super User
Super UserHello Anonymous
I put together what I think you are looking for.
From the linked sample file
You can download my sample file here and take a look at the measures:
https://www.dropbox.com/s/eu9rx5206hqpddo/FreightForcast.pbix?dl=0
@@jdbuchanan71 - I need help with the same issue, but im not able to download the pbix file.
Is it possible to share the measure used for FreightCostLY or FreightCostForecast ?
- jdbuchanan71
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 ) Thanks a lot