sum of Distinct count

[Anonymous]

How do I get overlap ?

if(rowno()=0,

sum( Aggr(count( Distinct Measure),Dimension))- Count (DISTINCT Measure), Count (DISTINCT Measure))

For example in below screenshot

Overlap = 33-13= 20

[vishsaggi]

Try this?

if(Dimensionality() = 0,

sum( Aggr(count( Distinct Measure),Dimension))- Count (DISTINCT Measure), Count (DISTINCT Measure))

[Anonymous]

Dimensionality()=0 or rowno()=0 =>one or the other will give same.

"sum( Aggr(count( Distinct Measure),Dimension))- Count (DISTINCT Measure)" this is what not working!

[vishsaggi]

So what is that you are seeing there? No value? Can you share some sample data to work on?