Adjust context filtering on multiple tables

[jazking123]

Hello,

Is it possible to adjust a second table based on the context filter of the first table using a common attribute, not the specific item filtered on?

In my example I'm using fruit and veg.

Ideally I'd like to select Golden Delicious in Table 1 and Table two would show all Apples, not just filter on Golden Delicious.

If it is possible, do I need to create a calculated column, calculated measure or calculated table?

Thank you in advance for any help you are able to provide.

Example Report

Example Report Link 

Gareth.

[v-eachen-msft · Accepted solution]

Hi @jazking123 ,

You could copy your current table and use SELECTEDVALUE() function to determine if the selected content is consistent. Then use filter to get your final result( each column must have a corresponding judgment DAX ). For example:

IF1 =
IF ( SELECTEDVALUE ( 'Table 2'[Type] ) = SELECTEDVALUE ( 'Table'[Type] ), 1, 0 )

 You need to set it to show "1" in the filter pane.

In addition, you could use slicer and it is easier to show the result.

[jazking123]

Thank you so much!

@v-eachen-msft Do you think it's safe to assume that there's no way to solve this without having to duplicate the dataset? The real dataset is significantly larger. If not, no problem, the solution is still manageable.

Thank you again,

Gareth