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.
Hi!
I´ve created this table containing all my my processes and corresponding factors. I want to use factors for each process beacuse when im forecasting i tend to see trends changing on process level.
So I´ve created my measure:
"ForeCastWithFactors = [Forecast] * CALCULATE(SUMX('ProcessFactors'; 'ProcessFactors'[ProcessFactor]))"
and row by row it works as expected, it increases the forecast by the factor (they are all 1.07 at the time)
However the problem is the total. its Obviously calculating the sum of all the factors x sum of forecast. and thus its not really usable in a bar chart for example.
Anyone know how to rewrite this so it works?
I did make a post about this earlier: https://community.powerbi.com/t5/Desktop/Measure-with-a-factor-table/m-p/421672#M193883
I did get help but the measure does not fill my entire calendar. Only until the end of april (Where my current data ends)
My measure for "Forecast" is created like this:
Measure: Result2016 = CALCULATE([Total Offered]; DATEADD('Dates'[Date]; -728; DAY))
Measure: Result2017 = CALCULATE([Total Offered]; DATEADD('Dates'[Date]; -364; DAY))
I´ve mixed with the number of days to get the weekends to line up for this year.
Measure: Forecast =
Var D1 = [Result2016]
Var D2 = [Result2017]
RETURN
DIVIDE(D1 + D2; 2; 0)
The proposed solution was this one and it does work like a charm and does what it is expected to do. Except that it seems to calculate only until my last record in April, see last picture.
Measure: ForeCastWithFactors = SUMX('ProcessFactors'; [forecast] * ‘ProcessFactors'[ProcessFactor])
Hi! Sorry for my bad english, hopefully this will clear things up a bit.
My current problem is this measure:
ForeCastWithFactors = SUMX('ProcessFactors'; [forecast] * 'ProcessFactors'[ProcessFactor]) It calculates correctly but it does not
fill my entire calendar for some reason. It only calculates until the end of April. I have no actual data after April.
My first measure "Forecast" however works fine and fills my entire calendar.
Measure: Forecast =
Var D1 = [Result2016]
Var D2 = [Result2017]
RETURN
DIVIDE(D1 + D2; 2; 0)
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |