DISTINCTCOUNT in total column of matrix is not dynamic

[Anonymous]

Hi,

I am obtaining the distinctcount of a table column and displaying it in a matrix. 

Example Table:

My Measure:

Test_DistinctN = DISTINCTCOUNT('Table'[Test])

 

My Matrix:

I would like the total to update when I am selecting the columns in order to slice the dataset.

i.e. if a and b are selected total = 2 

Note - It does work if I slice using a separate table to select the values. Just not the matrix itself.

[amitchandak · Accepted solution]

@Anonymous , I doubt selected visual can used by same visual, You can display that in another visual