Forum Discussion

farhanaizzatie's avatar
farhanaizzatie
New Member
1 year ago

Date range filter use only in calculation but not table visual

hi everyone, I have one problems where I have a date range filter in my report using transaction date in Db. this filter is not impacting the table visual as in I edit interaction and select None for...
Need Help
Tips and Tricks
Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

Ok, from my understanding

  • you have a slicer and table visual
  • The slicer has dates
  • You have set the slicer to not interact with the table visual
  • You want to have a leave measure in the table, that respects the date slicer

The problem is because the interation is set to None, there is no date filter context on the table for the leave measure to pick up.

Since you are creating a leave calculation, you should be turn the interation back on. You can get the filtered rows to reappear with the measure. in the measure you can use CALCULATE( , REMOVEFILTER( Date ) ) to remove the effect of the date slicer. With VALUES( date[date] ) you can grab all the dates from the slicer for use in your calculation