Forum Discussion
Dynamic table
hashtag_pete
You cannot achieve this if you want to use the cell in matrix 1 as the filter to change matrix 2.For your requirement, you could create a distinct table for the partner column, and use it to create another slicer to be used for matrix 2.
Table 2 = DISTINCT('Table'[Partner])m2 value measure= CALCULATE(SUM('Table'[Value]),FILTER('Table',[Entity]=SELECTEDVALUE('Table 2'[Partner])))Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
hashtag_pete , if both matrix or table entity and partner from the same table/s then it should filter the second table, because of interactions
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Hello Amit,
you are right, I forgot to mention this and added it now: of course I deactivated the interaction between the slicer (that goes on Entity) and the second matrix
This second matrix should display the Value of Partner in Matrix 1 as Entity and Value of Entity of Matrix 1 as Partner
hashtag_pete , if you deactivate interaction you can not pass the values. Not even to a measure