Total count for next years

Hi GrimReaperX 

You can refer to the following example.

The slicer table

The data table

Create a measure

Measure = IF(ISFILTERED('Table (2)'[Column1]),CALCULATE(SUM('Table'[Column2]),FILTER('Table','Table'[Column1]>SELECTEDVALUE('Table (2)'[Column1])&&'Table'[Column1]<=SELECTEDVALUE('Table (2)'[Column1])+5)),CALCULATE(SUM('Table'[Column2]),FILTER('Table','Table'[Column1]>YEAR(TODAY())&&'Table'[Column1]<=YEAR(TODAY())+5)))

Then put the column of slicer table to the slicer and create a table visual and put the data of data table and measure  to the visual.

Output

When the silicer is not chosen.

When the slicer is chosen

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.