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 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  

Need Help

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    5 years ago

    Hey Anonymous ,

     

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

     

    Regards,

    Tom

  • v-jingzhang's avatar
    v-jingzhang
    Community 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.