Forum Discussion
Filter using slicer
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.
If you want something to respond to a slicer, yes, it has to involve a measure or a visual.
3 Replies
If you want something to respond to a slicer, yes, it has to involve a measure or a visual.
Report is a table? Calculated tables and columns do not know about slicers. Slicers affect visuals and measures.
Yes ,Report is table , so in this scenario I have to create a measure just to calculate value ?
