How to only count unique subjects for each id?

[simonroschu]

Hi everyone, 

i am working on some data that look like this: 

ID	Subject
1	A
1	A
1	B
2	A
2	C
3	C
4	A
4	A
4	A
4	C

I want to count the subjects, but only the unique ones for each ID. In this example the result should be 7 (the ones with the red font).

Any clue ? Thanks for helping,

Simon 

[tresesco]

Try:

=Sum(Aggr(Count(DISTINCT Subject), ID))

[Vegar]

Is it correct to assume that you want to count the distinct unique combinations of Subect and ID? If so then you could use this calculation.

=count(distinct Hash128(ID,Subject))

[simonroschu]

Yes, thats correct. 

I tried your calculation and it works. I really hope its also working for bigger data

[simonroschu]

Thank you. It seems like its giving me the right result.