cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jazking123 Frequent Visitor
Frequent Visitor

Adjust context filtering on multiple tables

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?


Annotation 2019-11-08 081026.png
Thank you in advance for any help you are able to provide.

 

Example Report

Example Report Link 

 

Gareth.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Adjust context filtering on multiple tables

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.

 

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

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Adjust context filtering on multiple tables

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.

 

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

View solution in original post

jazking123 Frequent Visitor
Frequent Visitor

Re: Adjust context filtering on multiple tables

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,982)