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

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

    • 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

      • az38's avatar
        az38
        Community Champion
        6 years ago

        RonaldvdH 

        whats your desired output based on your data example?

        whats output you expect for slicer A and for slicer A+B? How it should look like?

         

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