Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Gareth.
Solved! Go to 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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |