You can add a yesno dimension that uses your dt_filter and then use that in the measure filtersdimension: dt_yesno { type: yesno sql: {% condition dt_filter %} your_date_field {% endcondition %} ;;}measure: sum_filt_by_dt { type: sum filters: [ dt_ye...

Are SQL-based derived tables what you’re looking for? You can create a derived table with a completely custom query with them.