Forum Discussion

RonaldvdH's avatar
RonaldvdH
Post Patron
6 years ago

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...
Need Help
RonaldvdH's avatar
RonaldvdH
Post Patron
6 years ago

I just did 🙂 because the result isn't correct when you select more then 1 project

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

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.

  • RonaldvdH's avatar
    RonaldvdH
    Post Patron
    6 years ago

    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