PowerPivot Distinctcount

[goss]

Hi all,

Using Excel 2010.

How can I get a Distinctcount of a Measure or how could I rewrite one or more of the Measures below?

With these Measures, I'm close, but the counts are not distinct.

The DistinctCount function appears to only accept a Column and not a Measure.

Current Measures:
Count of Processors:=count([ProcessorKey])

Count of Processors Value Correct:=CALCULATE([Count of Processors],FILTER(dimErrorValue,dimErrorValue[ErrorValueKey]=29))

Count of Processors Value FYI:=CALCULATE([Count of Processors],FILTER(dimErrorValue,dimErrorValue[ErrorValueKey]=47))

Count of Processors Value NA:=CALCULATE([Count of Processors],FILTER(dimErrorValue,dimErrorValue[ErrorValueKey]=78))

Count of Processors Value Opportunities:=CALCULATE([Count of Processors]-[Count of Processors Value Correct]-[Count of Processors Value FYI]-[Count of Processors Value NA])

Selected Month Count of Processors Value Opportunities:=Calculate([Count of Processors Value Opportunities],FILTER(dimCalendar,dimCalendar[ReportMonth]=[SelectedReportMonth]))

Thanks,
w

 

[goss]

Bump.