aggr?

[#1]

Hi,

can you please help?

I have data as follows:

Category     Id

A               1

B               2

C               3

A               4

B               5

C               3

C               6   

A               1

How to calculate in as a KPI that we have two ids with the same category (A - 1 and C -3)?

Many thanks for suggestion

Tommy

[vinieme12]

what do you want to calculate?

[swuehl]

Maybe something like

=Count({<Id = {"=Count(Id)>=2"}>} DISTINCT Id)

This will not check if the category is the same, just checking if there are multiple assignments for the same Id.

[swuehl · Accepted solution]

Or if you need to check this, maybe

Sum( Aggr( If( Count(Id)>=2, 1,0), Id, Category))

[#5]

This is what i needed, thanks so much.