Dynamic table

[hashtag_pete]

Hello all, 

I need some swarm intelligence 🙂

I have a table like this: 

Entity	Partner	Value
A	B	200
A	B	100
A	C	200
B	A	-200
B	A	-100
B	A	500
B	A	-150
C	B	150
C	A	300

In a Matrix Visual, I have Entity "A" via slicer selection. 

Now I want to click on the Partner "B" in this matrix, and according to this selection see in a second matrix all the posting of the Entity "B" (which is the same as Partner B) with "A" as a Partner. 

First, I wanted to create a dynamic table, but this is not possible I learned. How can this be achieved?

Added note: I already deactivated the Interaction between the slicer and the second matrix.

Thanks for your help!

hashtag_pete

[Anonymous · Accepted solution]

@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]

Hmm, ok, but how can I display all bookings of B with A, i.e. transforming the

- Partner selection B to an Entity B 

- Entity selection A to Partner A

[amitchandak]

@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

[hashtag_pete]

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

[amitchandak]

@hashtag_pete , if you deactivate interaction you can not pass the values. Not even to a measure