Distinct Count

[Anonymous]

Hi, 

Need help on DAX to find the Distinct Count of the users per day at different level. if we select a Matix table aand created a row headers as L2,Level1 and Userscount then the  sum of Distict Count of Level2 users should match with Level1 users distict Count. Please refer to the attachment for your reference.

Regards,

https://drive.google.com/file/d/1Rn5U3ABe8_fuQmay3HABtyCEjVa8UGnv/view?usp=sharing  

[v-jingzhang]

Hi @Anonymous 

Your expected result is not very clear. Can you update the link of file or provide dummy data in table format directly?

Usually when you want to get the distinct count values per day at different levels in a matrix, you can put date column and level column into the matrix. For example, Level as row field and Date as column field, or reverse. Then create a measure UserCount = DISTINCTCOUNT ( 'tablename'[user] ) and use this measure as Values field in the matrix. Then you will get what you want. 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[TomMartens]

Hey @Anonymous ,

the link you provided requires a login. Please provide a link that accepts an anonymous connection.

Regards,

Tom