Filtering a column based on the values in a different column in the current context

[ruve1k]

It's great to see this new section of the Mr. Excel message board!
I was wondering if any of the Pros could take a look at this thread and give some insight and hopefully suggest something more efficient.
Thanks!

 

[Jon von der Heyden]

Guys you are scaring the new people

If you are reading this and are new to PowerPivot, rest assured that what's being discussed here is VERY advanced relative to what you need to know.

Hell, even I don't understand Alberto half the time

I find it rather inspiring!

 

[David Churchward]

I find it rather inspiring!

I've been desperately resisting setting up a discussion "Who can confuse Rob the most?" and then handing over to Alberto!

 

[AlbertoFerrari]

I am actually just using a simple DISTINCTCOUNT([Column]) in the SQL Server 2012 RC0 release and I find that performance is much slower than the same formula with a SUM.

Sorry for not answering, it seems I did not receive mails for the update of the forum.
It would be of GREAT help if you can send me the workbook. I have used Distinct Counts over billions of rows without any problem thus it seems there's something well hidden in the formula that creates problems, I would like to check it on my PC, if possible.