I need Calculated table to be affected by Slicers

[iwf]

Hello, I created this calculated table:

PrevTwoTable =

SUMMARIZECOLUMNS(Activities_All[AccType];

FILTER( Activities_All;[ScheduledEnd] > EOMONTH(TODAY();-3) && [ScheduledEnd] < EOMONTH(TODAY();-2));

"PreviousTwo";

SUM(Activities_All[Count CRM Activities]))

In my Report I have many slicers on the first page. I want this calculated table to be sliced/affected by the slicers from the first page. I know, that calculated table is static, but I saw some post that there is ALLSELECTED functions or IN VALUE. But i couldnt incorporate these into may calculated table.

Is there any way to "learn" calculated table to be afected by slicers?

Thank you

[v-lili6-msft · Accepted solution]

Hi@ iwf 

After my research, when adding calculate table it can’t be afected by slicers.

And this link may give you some ideas.

https://community.powerbi.com/t5/Desktop/Create-dynamic-DAX-table-filtered-by-slicer-from-another-ta...

Best Regards,

Lin