Can't create table from another table removing filters

[Omar_Servin]

Hi, I have the table Table1 with just two columns, Column1 and Column2, I want to create another, realted table based con Table1 but without the filters applied, then I link both tables by bi-directional link between Column1 and Filter Table1[Column1]. My objective is that Table2 is not filtered at all, but I'm unable to do it, Table2 gets filtered as well.

I've tried CALCULATETABLE, FILTER, ALL, etc and nothing seems to work, this is code I currently have for testing, is redundant but still doesnt work:

Table2 = CALCULATETABLE(

    ALL('Table'),

    ALL('Table'),

    REMOVEFILTERS('Table')

)

I'm using Power BI Version: 2.118.828.0 64-bit (June 2023)

What am I doing wrong?

Thanks in advance

[Arul]

@Omar_Servin ,

Can you share the sample data and expected output?

Thanks,

Arul

[Omar_Servin]

Thank you the data of Table1 is very simple, this is its contents in CSV

Column1, Column2

a,1

b,2

c,3

Expected output: Visuals using Table2 should not be affected when I filter Table1

Actual output: Visuals using Table2 are affected when I filter Table1

[Arul]

@Omar_Servin ,

You can use edit interations to disable the interation between the visuals instead of doing it through DAX.

Check this : For disabling interactions - https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

Thanks,

Arul

[Omar_Servin]

I simplified the example to make it easier to demonstrate the point. But in reality I want to use some filters and some I don't. The problem is that I can't block filters coming from the original table, not individually nor colectively.