topic To list out the values from the count in KPI in App Development

To list out the values from the count in KPI

Yogesh_9999 — Thu, 07 Aug 2025 09:58:04 GMT

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

Re: To list out the values from the count in KPI

Kaushik2020 — Thu, 07 Aug 2025 12:44:49 GMT

Hi @Yogesh_9999 ,

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

Re: To list out the values from the count in KPI

savioricardog — Thu, 07 Aug 2025 12:59:58 GMT

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