Excel 2013: Powerpivot distinct count function counts empty cells

1
votes

Hi I'm using the powerpivot add-in for my excel 2013, as I want to have the distinct count function in my pivot tables.

I'm however experiencing that when I make a pivot table from my data table it counts the blank/empty cells also.

E.g. If I was suppose to have 4 unique I get 5 (as there also are blanks)

Does this makes sense Thanks Kristoffer

1
excelpivot-tablepowerpivotdistinct-values

1 Answers

1
votes

Try:

=CALCULATE(DISTINCTCOUNT(Table2[nums]), Table2[nums] <> BLANK())

Images to help:

enter image description here

enter image description here