Count if a Count greater than

[MMachado]

Hello everyone.

I've read many posts before write mine, but I had no success in my tries.

Objective: To count how many Codes in Column 'A'  have more than 1 distinct Code in Column 'B'.

So, in the example below we have codes 4850 and 4905 that have more than 1 distinct code in column 'B'.

I'd like to include this set analysis in a KPI. So it need to show '2' (for example below).

Thanks a lot!

Marcelo.

[Kushal_Chawda · Accepted solution]

try below

=count(distinct aggr(if(count(distinct B)>1,A),A))

[MMachado]

awesome, a answer too fast.
worked perfectly.
tks a lot

[Kushal_Chawda]

set analysis version

=count(distinct {<A={"=count(distinct B)>1"}>}A)