Calculated measure that won't sum

Hi,

Thank you for your reply, but this didn't solve the problem. My measure [Freightcost Forecast] still doesn't show a column total although I applied the changes to [FreightCost LY] as proposed. Actually, it didn't change the outcome of [FreightCost LY] either. What I want is that I only want [FreightCost Forecast] to show a value only in case [freightcost] is null (as for future dates), which works fine with the if statement in the measure formula. I think that the problem is that the measure gets caulcated as variant and data type variants don't sum in tables. I have tried to use value([Freight Cost Forecast]), but no change. 

Henrik

---

MFelix wrote:

Hi Anonymous ,

 

Measures in DAX are calculated based on context so the columns, slicers, filters visuals interactions can change the calculation of a measure.

 

In your case since the total row doesn't have dateforec[date] associated with it, because it's an aggregation line the result is blank.

 

You need to redo your measure to have an aggregator for making the sum of the rows. Something similar to:

 

[FreightCost LY] =
SUMX (
    Dateforec;
    CALCULATE (
        SUM ( transportorder[freightcost] );
        DATEADD ( dateforec[date]; -12; MONTH )
    )
)

Be aware that this can change your final result also, without any sample data is difficult to give you a better answer.

 

If this measure doesn't work please share a sample of your model.

 

Regards,

MFelix

---

Henrik