DAX help

[JS]

Hello all. 

I have a table below, 

Unique ID            Team

      1                        A

      1                        A

      2                        A

      2                        B

      3                        A

      3                        C

      4                        A  

How can I build a expression so that I can count the number of Team by Unique ID? I.e., For Unique ID 2, there will be 2 counts, Unique ID 1 will have 1 count because there is only one "A"

Thanks in advance! 

[v-jiascu-msft]

@JS

Hi,

You have gotten some good ideas. Actually, you can get this without a measure if you want a table visual.  Drag Team and Unique ID to values.  Make sure Unique ID is “Don’t summarize” and Team is “Count(Distinct)”. The formula by @Anonymous works.

Best Regards!

Dale

[Anonymous]

@JS Team_CT = COUNTA(Table1[Team])

Then when you use it, if the Unique ID is an int you would just make sure it wasn't summed, or make it a text field so the id isn't aggregated as well.

[JS]

Hello. Thanks for your response. 

I have tried the above mentioned DAX, it isn't working... I still get count of 2 for Unique ID 1. 

[Anonymous · Accepted solution]

What about:

DISTINCTCOUNT(Table1[Team])