Filter on name but not by date between 2 matrixs

[Haydn_R]

Using desktop powerbi I have the following columns in a martix visual.

1. ‘LLAC_TFR_TRENDS’[Calls]
2. ‘Distinct Week Ending Date’[Week Ending]
3. 'QUEUE_CD'[Queue]

In the another matrix visual I have the following columns

1. ‘LLAC_TFR_TRENDS’[Calls]
2. ‘Distinct Week Ending Date’[Week Ending]
3. ‘TRANFERS_TRENDS’[Transfer X %]
4. ‘TRANFERS_TRENDS’[Transfers_X]
5. 'QUEUE_CD'[Queue]

Requirement:

When I select a value for Queue_CD it is also for a Week Ending, but I want to show all Week Ending for that Queue_CD in the second matrix.

Below is an example of visual 1. If I select Queue1 for 28/04/2024, please see the table below as to the desired result

Week Ending	Queue	Calls
28/04/2024	Queue1	500
21/04/2024	Queue2	400
21/04/2024	Queue1	100
14/04/2024	Queue1	250
7/04/2024	Queue1	8
31/03/2024	Queue1	7
24/03/2024	Queue1	300
17/03/2024	Queue1	450

Here and example of the result I want to achieve. So I select Queue1 for 28/04/2024, but the table below will show all Week Ending dates for Queue1

Week Ending	Calls	Transfers	Transfer%
28/04/2024	500	6	1.20%
21/04/2024	100	76	76.00%
14/04/2024	250	61	24.40%
7/04/2024	8	3	37.50%
31/03/2024	7	5	71.43%
24/03/2024	300	50	16.67%
17/03/2024	450	49	10.89%

[v-linyulu-msft · Accepted solution]

Hi,@Haydn_R 

Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

2.First of all, there is no way for us to fulfill your requirement for the time being, because once there is a relationship between the tables, then the filtering case is inevitably fulfilled when we use the matrix view for selection, as shown in the figure below:

3.So in cases where there is a relationship between tables, I would recommend using the slicer :

4.If you still need to realize your needs by clicking in the matrix, we recommend that you create a table with no relationship and then implement it through the DAX function:

Measure = IF(MAX('Table'[Queue])=MAX('QUEUE_CD'[Queue]),1,0)

5.Here's my final result, which I hope meets your requirements.

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Leroy Lu

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