Sameperiod Lastyear Issue

Hi everyone

I have some issue about function sameperiodlastyear,

I want to compare data between present year and last year value by using sameperiodlastyear, for whole data is ok, but when i filter select some product, i found my date data is not continue because "The relationship between date table and data table is both relationship " then the function is not calculated, so i try to solve with crossfilter function to "active single relationship" but it won't work.

Could anyone can suggest solution for this issue?