To list out the values from the count in KPI

[Yogesh_9999]

I have a kpi which shows count of the users who are also present in other Dept’s excluding the selected Dept. Now, i need to listout the other Dept’s where the user is present.  

i used “Concat(DISTINCT {<Dept= e(Dept),User= p(userE)>} Dept, ', ')” which gives comma separated values. But i need to list the results in detailed tabular format

[Kaushik2020]

Hi @Yogesh_9999 ,

Are you looking output same as below in a table format ?

[savioricardog]

Hi @Yogesh_9999 
I used this measure in KPI:
"Count(DISTINCT {1< user_id = P(user_id), department -= {"$(=Only(department))"} >} user_id)"

And in the table, I used the same measure, but for the Department dimension, I did the following:
"Dim -> department -> Limitation -> Exact Value -> '>=' -> "department <> Only(department)"

and it ended up like this