Removing negative values for a table visual

[Anonymous]

I'm working on a project where I have calculated a figure between two base values. The results are in the left table and you can see some values are positive and some negative.

My next step is to only take the positive numbers and pivot them into a table on the right. I'm having a really hard time figuring out how to do this. If I use the new measure in the filters and select "is greater than or equal to" and type 0, it filters out results in my pivot table, not the base values. Is there a way to do this?

Here's the base formula to calculate the field if there's maybe an edit I can make to it. I only need anything that's equal or greater than 0.

Response = AVERAGEX('Dupes Removed',DATEDIFF('Dupes Removed'[Field 1],'Dupes Removed'[Field 2],day))

Cheers!

[Greg_Deckler · Accepted solution]

@Anonymous I *think* you are going for this:

Measure =
  VAR __Table = 
    ADDCOLUMNS(
      'Dupes Removed',
      "__Diff", DATEDIFF('Dupes Removed'[Field 1], 'Dupes Removed'[Field 2], day)
    )
  VAR __Result = AVERAGEX( FILTER( __Table, [__Diff] > 0 ), [__Diff] )
RETURN
  __Result

[Anonymous]

Brilliant, thank you so much! THis was exactly it. I just updated to >= to capture zeros and it's exactly what I needed. I really appreciate the help, this is amazing!