Dax to ignore field slicer in a table but keeping the filter

[AGo]

Hello,

I've got this table:

Date		Value
1/1/22		2
1/1/22		3
1/1/22		5
1/1/22		1
2/1/22		5
2/1/22		3
3/1/22		1

I use a filter visual to filter >="2/1/22"
I would like to print in a table visual these values, so I need a DAX function that ignores the date in the table but keeps the date from the filter (using ALL() in a calculate makes the measure ignore both the filter and the data column in the table visual):

Date		Sum of Values	Cumulative sum starting from filter date
1/1/22		11
2/1/22		8	8
3/1/22		1	9

Thanks for support!

[Rendani_motlopi]

You're sort of skirting the generally intended behavior of slicers, so this isn't quite as simple as you might think it ought to be.

To do this, create a new disconnected parameter table for the IDs:

dimID = VALUES(Table1[Id])

Use this new table for your slicer and write a measure that reads these values.

SumNum =
CALCULATE (
    SUM ( Table1[Num] ),
    KEEPFILTERS ( Table1[Id] IN VALUES ( dimID[Id] ) )
)

Put this in your table and it should behave as expected provided you set 'Show items with no data' on the Table1[Id] column.

Result:

[AGo · Accepted solution]

I found how to solve this using ALLSELECTED() in a MINX() that does exactly what I meant without creating disconnected parameters. Thanks everybody anyway!