How to make date columns filterable

Question

My data sheets span from 2016 to 2022，I filter the data behind by the previous time period, such as 2016 to 2018，The table name is "ALLORDER",Measures below&nbsp;_Result = 
    var tb1 = FILTER(VALUES(ALLORDER[magic]),[order_count_2016]+[order_count_2017]+[order_count_2018]&lt;=20)
    var tb2 = FILTER(tb1,[avg_profit_2016]&gt;=0.4 || [avg_profit_2017]&gt;=0.4 || [avg_profit_2018]&gt;=0.4)
    var tb3 = FILTER(ALLORDER,ALLORDER[magic] in tb2 &amp;&amp; ALLORDER[date].[year]&gt;2018)
    return
    calculate([_PROFIT],tb3)

[order_count_2016] = COUNTX(FILTER(ALLORDER,ALLORDER[date].[year]=2016),ALLORDER[profit])

[avg_profit_2016] = 
    var tmptable = FILTER(ALLORDER,ALLORDER[date].[year]=2016)
    return
    SUMX(tmptable,ALLORDER[profit])/COUNTX(tmptable,ALLORDER[profit])&nbsp;The calculation turned out to be correct！But put it on the visual table,use date column filter,it doesn't work.The other column works,like this&nbsp;How can I fix this and be able to filter by date

anonymous · Answer

Hi&nbsp;RuyiLuo&nbsp;
Is your date column filtered to exclude 2016? As you can see from your measures that your measures are fixed-years, make sure that you include these fixed years in your year filter. and can you provide some sample data or pictures so that we can better advise you?
&nbsp;
Best Regards!
Yolo Zhu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.