Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Distinct Count

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 Distic...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

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.