Interacting with tables on 2 pages, tables are linked via a measure

[jimmyfromus]

Hi, 

I have 2 tables and they interact with each other fine on one page. They are linked via a filter measure but I now need to move one of the table to another page.  i'm not sure how can they interact with each other on separate pages. I was looking at drill through but this only works with columns or values that are similar on both visuals? Thanks for any help. 

The Filter measure looks like this. 

Filter Measure =
VAR __selectedcontact = SELECTEDVALUE ( 'members'[Contact (_contactid)] )
VAR __selectedcompany = SELECTEDVALUE ( 'members'[Company (_accountid)] )
RETURN
SWITCH ( TRUE(),
NOT ISBLANK ( __selectedcontact ) && __selectedcontact <> "", CALCULATE ( COUNTROWS ( 'Merge DAX' ), TREATAS ( { __selectedcontact }, 'Merge DAX'[ContactID] ) ),
NOT ISBLANK ( __selectedcompany ), CALCULATE ( COUNTROWS ( 'Merge DAX' ), TREATAS ( { __selectedcompany }, 'Merge DAX'[CompanyID1] ) ),
1
)

[Anonymous · Accepted solution]

Hi  @jimmyfromus  ,

The Sync slicers feature doesn't work accross tiles in a dashboard，The Sync slicers applies to the two pages of the report, and the dashboard is a function on the services, not applicable to the synchronization between the two dashboards

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi  @jimmyfromus  ,
You can use Sync slicers.

According to your description, I create this data：

Table1：

Table2：

I created a measure to calculate the amount with ID < = 4 when company is a

Measure = IF(MAX('Table2'[company])="A",CALCULATE(SUM('Table'[amount]),FILTER('Table','Table'[ID]<=4)),BLANK())

Here are the steps you can follow：

1. Find view – sync slices

2. Setting in sync slices

3. Select the value in slicer in page1, and Page2 will also have influence

Page1：

Page2：

You can downloaded PBIX file from here.

This is a related document about Sync slicers, hope it will help you:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicer...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jimmyfromus]

@Anonymous Thanks. That works on the report but I'm using dashboards. Is it also possible to sync between dashboards? Thanks again. 

[amitchandak]

@jimmyfromus , Slicer can be sync. But not visuals. Drill through is the only option across pages.

[jimmyfromus]

@amitchandak I don't have the same columns though in the 2 tables. The interaction between the 2 tables only happens via the filter measure. Can i still do this with drill through?