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
az38's avatar
az38
Community Champion
6 years ago

Hi RonaldvdH 

maybe this will help:

Cumulatieve HC geforecast =
CALCULATE ([Totaal geforecast aantal HC];
FILTER(
ALL('Forecast FttH');
'Forecast FttH'[Week]<=MAX('Forecast FttH'[Week]) && 'Forecast FttH'[Project] = SELECTEDVALUE('Forecast FttH'[Project])
))

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

RonaldvdH's avatar
RonaldvdH
Post Patron
6 years ago

az38  thanks for your quick response and it looks like it works but i need to examine your solution further.

What i can see is that is works fine when i select just 1 project but when i select both the measure doesn't seem to work

 

or in the very least the result is very strange

 

Any ideas ?

  • az38's avatar
    az38
    Community Champion
    6 years ago

    RonaldvdH 

    if you select both project what your desired result? project A + projcet B or it still should be divided?

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    • RonaldvdH's avatar
      RonaldvdH
      Post Patron
      6 years ago

      Then it should be combined to 1 result

       

      Selection           Value

      Project A             200

      Project B             300

      Project C             200

      Project D             100

      Project A+B         500

      Project A+B+C    700

      Select All              800

      • az38's avatar
        az38
        Community Champion
        6 years ago

        RonaldvdH 

        so, let us know if my measure will not work

         

        do not hesitate to give a kudo to useful posts and mark solutions as solution