Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to derive the DAX = "Total Latest Forecast" BUT i cannot get the total to sum to 1003 + 3002 +2004 =6009 .... Instead I get 2004 . Can you help ?
Solved! Go to Solution.
Well, there is another solution in this case:
Total Latest Forecast =
SUMX (
SUMMARIZE (
Fact_Forecast,
Fact_Forecast[client],
"Date", MAX ( Fact_Forecast[fcst cutoffdate] ),
"Total Forecast", MAX ( Fact_Forecast[Total Forecast] )
),
[Total Forecast]
)
You may redownload the sample file if you want, it is updated.
excellent.. thank you.. i see by summaring, you are returing only forecast relevant to the max date.. then sum that expression..
Exactly, simple and straightforward.
You're alomst there, just need to adjust your filter a little.
Total Latest Forecast =
CALCULATE (
SUM ( [Total Forecast] ),
FILTER ( ALLEXCEPT ( Fact_Forecast, Fact_Forecast[client] ),
[fcst cutoffdate] = MAX ( [fcst cutoffdate] )
)
)
You may check this sample file
i notice your total = 2004 instead of 6009.... is there a way where it sums up to 6009
Well, there is another solution in this case:
Total Latest Forecast =
SUMX (
SUMMARIZE (
Fact_Forecast,
Fact_Forecast[client],
"Date", MAX ( Fact_Forecast[fcst cutoffdate] ),
"Total Forecast", MAX ( Fact_Forecast[Total Forecast] )
),
[Total Forecast]
)
You may redownload the sample file if you want, it is updated.
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
43 | |
26 | |
21 |