2 matrix and how to display details in a table visual

[FrenchNicolas]

Hello,

I need some help...

I have one table "users" and one table "applications" linked together (one to many, through ID field)

I have a first matrix with:

line = users[manager]

column = applications[status]

value = number of applications[ID]

I have a second matrix with :

line = users[manager]

column = none

value = a measure that count the number of ID present in "users" but not present in "applications" ==> 

COUNTAX(EXCEPT(VALUES(Users[ID]),VALUES(applications[ID])),Users[ID])

I have a also table visual (users[ID],users[Name],applications[status]), where it shows me details of people when I click one a square/box of the first matrix

but if i click one a square/box of the second matrix, it does not filter the table visual. (because i used a measure...)

what i want: 

if I click on one the first or the second matrix, I would like it to show me the details of the people concerned in the table visual

do you have an idea ?
thanks !

[FrenchNicolas · Accepted solution]

I was finally able to handle my problem via creating a calculated column. thanks

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523