Forum Discussion
Can't create table from another table removing filters
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:
I'm using Power BI Version: 2.118.828.0 64-bit (June 2023)
What am I doing wrong?
Thanks in advance
4 Replies
- Arul
Super User
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
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=powerbi-desktop
Thanks,
Arul
