Forum Discussion

chintusasmal123's avatar
chintusasmal123
Helper I
2 years ago
Solved

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...
Need Help
  • HotChilli's avatar
    HotChilli
    2 years ago

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

HotChilli's avatar
HotChilli
Community Champion
2 years ago

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

  • chintusasmal123's avatar
    chintusasmal123
    Helper I
    2 years ago

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