Slicer doesn't work for table which is created in variable

Question

Hi,&nbsp;&nbsp;I'm trying to create a new table for some specific date periods and percentage changes for some of them. I used calculated column for deposit and brought measures per row.&nbsp;&nbsp;It looks like as below,&nbsp;&nbsp;&nbsp;The issue is that, country- brand and brandsplit slicers don't affect the table. How can I adjust my table "_table1" as variable?&nbsp;&nbsp;&nbsp;The measure for yesterday,&nbsp;&nbsp;Thank you,VK&nbsp;

hotchilli · Answer

calculated columns don't react/change to slicers.

vkisa · Answer

thank you&nbsp;HotChilli&nbsp;&nbsp;What if we create the table with crossjoin function and add brand, country columns as below? Can we adjust "yesterday" measure regards to that?&nbsp;&nbsp;&nbsp;