Sum distinct values per category

[Anonymous]

I am calculating distinct id for each category and get this table which is correct and how I would like it. But when Power BI is calculating the total it seems like it is calculating the distinct id over all, without taking into account that some IDs are within multiple categories. I would like the total to be 5+6+2=13 but instead the total is 8 since a lot of IDs are in multiple categories. 

Category	distinct count
cat 1	5
cat 2	6
cat 3	2
total	8

[amitchandak · Accepted solution]

@Anonymous , Try like

sumx(values(Table[Category]),[distinct count])