I have heard amazing things about PowerPivot but for me it's not been so helpful. Pivot charts are often using a count function and this is where me and PowerPivot have our differences. I have a very large data set and why I am using PP. However it doesn't recognize nulls, so my counts are not true counts. My thought is to add a calculated column with DAX like this:
=if(ISBLANK([status]),0, [status])
So I want a 0 instead of a blank, but the status value to show when there is one. I'm not the best at excel, so I think my function is wrong and why PP doesn't like it. I can get 0's for nulls and 1's for not nulls, but I need 0's for nulls and the actual cell value to display when not null.