filter

[tatuspark]

Hello i have 2 views and each view has a date field but i want to use a single date field to filter the measures of the 2 views together. I have made the join of the 2 views in my model and here is my code but the filter does not act on the foreign measure.how to filter the measures of one view from the date field of another view.

Thanks

measure: sum_total_ht {
    type: sum
    value_format_name: decimal_0
    sql: CASE
          WHEN {% condition date_filter %} CAST(${date_sales_date} AS TIMESTAMP)  {% endcondition %}
          THEN ${derived_table_sales.total_ht}
        END ;;
  }