Calculations using input from a What-If

New to Power BI,

So perhaps I'm approaching this from the wrong angle ?

Anyway...

1.) I have an imported table with the Field/Column = the Date of the Last Payment Received on an account.

Let's call it [Activity Date]

2.) I have a Calculated Column Let's call it [CPM] which is the number of days since the [Activity Date]

[CPM] = DateDiff(Table_Name[Activity Date],Now(),day)

This appears to be working as expected.

3.) I then have a SLICER that allows the user to select a number of days from 0 to 365.

So "0" days since last payment out to a full year.

Let's call the value of the SLICER [Slicer Value]

4.) My plan was to then have a 2nd Calculated Column [Include] = to the difference between the value selected from the SLICER and the previously calculated [CPM] so

Include = Table Name[CPM] - [Slicer Value]

5.) I could then set up a Page filter for Records where the result of [Include] > 0

So the user could filter the Visualizations on the page for those accounts which had not received a payment in MORE THAN the number of days selected by the SLICER.

This might be cumbersome, and I haven't even got to experimenting with the Filter yet.

What seems odd is that the 2nd calculation

Include = Table Name[CPM] - [Slicer Value]

Is not producing the expected values, for example

If Table Name[CPM] = 7

and

[Slicer Value] = 0

Then the result should = 7, but instead = -23

And when I move the slider to change the value of the Slicer, nothing happens.

The value of [Include] does not change.

What could I be doing wrong ?

Thanks.