transfer selected data from one table to another (visual interaction between pages)

[Karola]

i looking for a way to transfer data from one table to a table on another tab. 

example: 

on tab 1 i have a table with the following items: 

Letter

A

B

C

D

E

F

no i selected or filtered so i only have 

Letter

A

B

C

D

Is there a way to only take A, B, C and D to another table on tab 2

like: 

tab 2

Letter   measure

A          24

B          50

C          35

D          15

i dont want to see all the data in my tab 2.. only the data i have selected/filtered on tab 1

[v-yalanwu-msft]

Hi @Karola ,

According to your description, if the two tables are related, you could directly use the sync slicer, if not, you could add a flag measure，as follows:
1．IF two tables have relationships, you could use sync slicer

2.IF two tables don’t have relationships ,You could add a flag measure and apply it in filter :

flag = IF(MAX('Table (2)'[Letter]) in ALLSELECTED('Table'[Letter]),1)

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Karola]

@amitchandak Maybe i don't get you or you don't get me but it has nothing to do with the measure. 

let's see if i can make a simpler example

I have 2 tabs (pages) in my power Bi report. 

on both tabs i have a table visual. 

both have the same columns 

cow   milk (kg)

1        30

2        20

3        25

4        35 

5         51

6         60

7         15

etc.

now i would like to take a selection of the list to the table visual on tab 2

so i ctrl click on cow 1 and 2 in the table on tab 1 for example and only those cows are visible on the table on tab 2

so my result is then on tab 2

cow    milk (kg)

1         30

2         20

its like visual interaction but not on the same page. 

is something like that possible.. 

[amitchandak]

@Karola , Create a measure like (used your measure in that) and use with letter of table 2

measure =
calculate([measure], filter(table2, table2[Letter] in values(table1[Letter])))

or you can have count(Table2[letter]) in place of measure, as per need