Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |