Filter on appended table

[carlosmeep]

I have 2 tables (table 1 and 2), and I have appended one to another to get table 3.

The problem is there is a slicer from table 1 that affects a card from table 3, and that is what I want to avoid. It filters the rows of table 1 on table 3 and the card works on the rows of table 2 (that are in table 3).

But It gets weirder (more complicated).

I need to use the slicer to filter the values on the rows of table 2.

This is the measure that I need to make work:

regs = CALCULATE(COUNTROWS('table3');FILTER('table3';'table3'[column_from_table2] = SELECTEDVALUE([column_from_table1])))

Hope You can help me.

Thank You very much!!

[az38 · Accepted solution]

Hi @carlosmeep 

Maybe it will be enough just to disable relationships between table1 and table3 ?

do not hesitate to give a kudo to useful posts and mark solutions as solution