count distinct

building semantic layer
1

Hi experts,

I need to make a calculation in a measure object like this

count(distinct case when (count(distinct x||y)>1) then A||B else 0 end )

i mean i need to count a set of coulmns only when the count of other distinct columns is >1.

i know the above is blunder cos i am trying to nest the aggregate functions but that would best describe my problem.

How do i do that.

BOXIR2 TERADATA

kbharadbo (BOB member since 2009-05-19)

2

Your requirement is not clear, please provide sample data and what output you are looking for.

Rakesh_K :india: (BOB member since 2007-12-11)