topic Re: Slicer doesn't work for table which is created in variable in DAX Commands and Tips

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

vkisa — Thu, 18 Apr 2024 09:58:15 GMT

Hi,

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.

It looks like as below,

The issue is that, country- brand and brandsplit slicers don't affect the table. How can I adjust my table "_table1" as variable?

The measure for yesterday,

Thank you,

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

HotChilli — Thu, 18 Apr 2024 10:19:24 GMT

calculated columns don't react/change to slicers.

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

vkisa — Thu, 18 Apr 2024 10:35:57 GMT

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

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

HotChilli — Thu, 18 Apr 2024 13:52:05 GMT

I'm not sure what you are trying to do.

Can you use Field parameters?

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

vkisa — Thu, 18 Apr 2024 14:16:22 GMT

Actually, I created a table that shows the measures by date periods. That is why I created table for these date periods like below,

But I need to add two rows that give %change of yesterday and SDLM, MTD and SPLM

I'm stucked how I can handle that...