How to measure a distinct count across category and get total?

[Anonymous]

I have a table with two columns. First column contains IDs and second column contains a Type. I would like to calculate the total count of unique IDs across the type.

ID	Type
xxxx	A
yyyy	A
zzzz	A
kkkk	A
jjjj	A
xxxx	B
yyyy	B
zzzz	B

I tried following code:

calculate(DISTINCTCOUNT(Table2[ID]),ALLEXCEPT(Table2, Table2[Type]))

When I add a slicer for Type and select any one of the type, I get the correct distinct counts of IDs for a selected type (For example: When I select Type as B in the slicer, I get 3 unique count of IDs). But, when I clear the filter I get the answer as 5. I would like to get the answer as 8 because there are 8 unique IDs across the Type.

[Fowmy]

@Anonymous 

You can is this measure:

DCount = 
SUMX(
    SUMMARIZE( Table , Table[Type] ),
    DISTINCTCOUNT(Table[ID])
)

[Anonymous]

Using this, I am getting the answer as 10. I want to show 8 as an answer because there are 8 unique IDs across the Type.

[Fowmy · Accepted solution]

@Anonymous 

I am getting 8, can you check your data to see if it looks like mine

[Anonymous]

Hey @Fowmy , Thanks for your reply. I have following table.

ID	Type
xxxx	A
yyyy	A
zzzz	A
kkkk	A
jjjj	A
xxxx	B
yyyy	B
zzzz	B

In your table, you missed ID "kkkk"

[Fowmy]

@Anonymous 

Try this 

DCount = 
SUMX(
    VALUES(Table3[Type] ),
    CALCULATE(DISTINCTCOUNT(Table3[ID]))
)

[Anonymous]

Hey @Fowmy  for nudging me in the right direction. I used the following function. 

SUMX(VALUES(Table2[Type]), CALCULATE(DISTINCTCOUNT(Table2[ID])))

[aj1973]

Hi @Anonymous 

a simple 

count of ID_ = COUNT(Table2[ID])

would it work?