Forum Discussion
How to get count for user data
Source.Name user status 2023-01-02.csv xyz OOO 2023-01-02.csv abc WFH 2023-01-02.csv pqr OOO 2023-01-03.csv xyz HYD-RHJ 2023-01-03.csv abc ...
Hello jahidfazal ,
use this measure
StatusCount = DISTINCTCOUNT('Table'[Status])
you just change the "table" to the table's real name.
the visualise it along with the user field in a table.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi @Idrissshatila Thank you for your response.
I used your solution but it is not working as expectedjahid OOO jahid HYD-RHJ jahid HYD-ILABS jahid WFH jahid WFH For able table I am expecting output as 2 be getting as 3. Please let me know if I am missing something.
We have a column statuses which has values like HYD-RHJ, HYD-ILABS, GGM, BLR which needs to be considered for count any other value must not be considered. Also, one user might be in any of statuses (HYD-RHJ, HYD-ILABS, GGM, BLR), so here we will be count if a user is in any of the above statuses.
