Forum Discussion

PBE's avatar
PBE
Icon for Helper II rankHelper II
3 years ago
Solved

Measure to Deal with Negatives in Calculation

Hi, Thanks in advance. I couldn't find a way of uploading a file to the forum. The link below is a google drive link to a copy of the file. https://drive.google.com/file/d/150YjoWvugCp6-dEOnypDtCqF...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    That's unfortunately exactly the point. The result cannot be modified by filters.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

That selective addition is not something you can do in DAX.  You can use List.Accumulate in Power Query for this but that will result in a column, not a measure.

  • PBE's avatar
    PBE
    Icon for Helper II rankHelper II
    3 years ago

    Thanks lbendlin . Not sure what list.Accumaulate is, will have a look. I'm not sure it matters if the result is a column so long as it does the calcultion and can be filtered by a slicer.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      That's unfortunately exactly the point. The result cannot be modified by filters.

      • PBE's avatar
        PBE
        Icon for Helper II rankHelper II
        3 years ago

        Thanks for letting me know. I'll have to think of another way of doing it.