Selecting cell from matrix to see rows from table

[Anonymous]

Hi,

I have two database views - first I use in matrix and second in table. Both of views have diffrent columns, the same count of rows and
they are connected by Id column (which is only column which exists in two views).
In matrix I have some measures calculating count in which there is a "T" value.

measures_A1 = CALCULATE(COUNTROWS(view_A), view_A[isTrue]="T")
measures_A2 = CALCULATE(COUNTROWS(view_A), view_A[isSold]="T")

No, I want to click on matrix cell with a specific count and then see in table below only rows which make up this count.

For example:

Matrix:

	measures_A1	measures_A2
Row1	2	4
Row2	7	3

and after clicking on cell with "3" value I want to see only 3 rows in table (not all rows from view_B):

Table:

Col1	Col2	Col3	Col4
ac	ac	sdf	z
z	qwe	hj	ds
asd	ww	jkljh	yrt

Currently when I'm clicking on "3" then I see 10 rows in table. So it seems like I'm selecting row from matrix not a specific cell.
I want to select one cell from matrix and then see in table only rows which make up this count. If it is possible? Or mayby I shoud use diffrent visualisations?

[Anonymous]

@amitchandak , thank you for your response.

Using visual level filter actually works, but ...
Is there any way to do this without using a filter? What I mean is that when you select a cell from the matrix, the rows in the table will be dynamically displayed (without applying filter).

[v-jingzhang]

Hi @Anonymous 

The filter view_A[isTrue]="T" provided by the measure is not able to be passed to other visuals. You can click a cell in the matrix and hover your mouse cursor over the filter icon of the table to see which filters are applied to this visual. You will find that only the row value applied. Actually you are just selecting a row when you think you select a cell.

If you put some column in Columns fields, then you will see the row and column values are applied to filter the table when you select a cell.

Maybe you can consider add column fields to the matrix?

Regards,
Community Support Team _ Jing

[Anonymous]

@v-jingzhangThanks for the explanation. Now I know that I am selecting the row and not the cell.
Of course I can add columns to matrix, but when I have more than one columnt then on visualisation it looks like this:

I have two columns. Each of this columns can be 'T' or blank, but only one is shown in the matrix in the header.
1. Can I somehow remove this "isTrue" header (or add "isSold")?

Additionally, I have these columns "duplicated".
2. How can I remove the areas which are marked with an 'X'?

[v-jingzhang]

Hi @Anonymous 

When putting multiple columns in the columns fields, they will be displayed as different hierarchy levels. This is a good of Matrix to show hierarchy data, but it's also a limit because it cannot display these columns at the same level. I would suggest to create Matrix visuals for isTrue and isSold data separately, and remove the interaction behaviors between both using Edit interactions.

To remove the blank columns, you can apply the visual filter.

I cannot think of better workarounds for this.

Regards,
Jing

[amitchandak]

@Anonymous , This filter is part of measure view_A[isSold]="T" , that will not pass to drill

so new table should have visual level filter for that or all measures having that filter