Forum Discussion
Help me please ;)
I need to upgrade my current measure to include a variable Cumulatieve HC geforecast = CALCULATE ([Totaal geforecast aantal HC]; FILTER( ALL('Forecast FttH'); 'Forecast FttH'[Week]<=MAX('Fo...
Hi RonaldvdH ,
When you select multiple projects in slicer, what results should be shown while the project is in the same week? It should be calculated cumulative values together or separately based on the projects? It should show the total values in the total row like below? If so, you just need to create a new measure by SUMX function and use the formula that az38 suggested. Or it should show the total values in each row?
Measure 1 = SUMX('Forecast FttH',[Measure])
Please show your expected results. Then we will understand clearly.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-xuding-msft and az38
ive altered the measure to:
Test1 = SUMX('Forecast FttH';[Totaal geforecast aantal HC])
and changed the formula provided by az38 to:
Cumulatieve HC geforecast =
CALCULATE ([Test1];
FILTER(
ALL('Forecast FttH');
'Forecast FttH'[Week]<=MAX('Forecast FttH'[Week]) && 'Forecast FttH'[Hoofdproject] = SELECTEDVALUE('Forecast FttH'[Hoofdproject])
))
But unfortunately there was no difference in the outcome, ive added a few picture to hopefully clarify what im trying to do
Project A, the result (red line) is correct (200 a week makes a line with values 200, 400, 600 etc)
Project B, the result (red line) is correct (350 a week makes a line with values 350, 350, 450 etc)
Based upon the values in the bars
Project A+B, the red line is strange because why would it start at 5800 in wk 2020-38 if both Project A and B start in wk 2020-02 and 2020-07
The result should be the cumulative value (as a line) of Project A and B starting from wk 2020-02 until (in this case) 2020-37