Filter using slicer

[chintusasmal123]

I'm tyring to filter table using year value from slicer , 
Report =
var Selected_Value = SELECTEDVALUE('Year'[Year])
return UNION(
ROW("Quarters","Last Quater","Number",CALCULATE(COUNT(HRSSNew[ID]),FILTER(HRSSNew,HRSSNew[Year] = IF(ISBLANK(Selected_Value),YEAR(TODAY()),Selected_Value) -1 && HRSSNew[QuarterNo] = 4 && HRSSNew[ProcessType] = "Reports"))),
ROW("Quarters","Quater 1","Number",CALCULATE(COUNT(HRSSNew[ID]),FILTER(HRSSNew,HRSSNew[Year]= IF(ISBLANK(Selected_Value),YEAR(TODAY()),Selected_Value) && HRSSNew[QuarterNo] = 1 && HRSSNew[ProcessType] = "Reports"))),

ROW("Quarters","Quater 2","Number",CALCULATE(COUNT(HRSSNew[ID]),FILTER(HRSSNew,HRSSNew[Year]= IF(ISBLANK(Selected_Value),YEAR(TODAY()),Selected_Value) && HRSSNew[QuarterNo] = 2 &&HRSSNew[ProcessType] = "Reports"))),

ROW("Quarters","Quater 3","Number",CALCULATE(COUNT(HRSSNew[ID]),FILTER(HRSSNew,HRSSNew[Year] = IF(ISBLANK(Selected_Value),YEAR(TODAY()),Selected_Value) && HRSSNew[QuarterNo] = 3 && HRSSNew[ProcessType] = "Reports"))),

ROW("Quarters","Quater 4","Number",CALCULATE(COUNT(HRSSNew[ID]),FILTER(HRSSNew,HRSSNew[Year] = IF(ISBLANK(Selected_Value),YEAR(TODAY()),Selected_Value) && HRSSNew[QuarterNo] = 4 && HRSSNew[ProcessType] = "Reports"))
)) 

It's not recognising year slicer value , so default Year=2024 is coming.

[HotChilli · Accepted solution]

If you want something to respond to a slicer, yes, it has to involve a measure or a visual.

[HotChilli]

Report is a table?  Calculated tables and columns do not know about slicers.  Slicers affect visuals and measures.

[chintusasmal123]

Yes ,Report is table , so in this scenario I have to create a measure just to calculate value ?