Hi all,

Usineg Excel 2013.

I am trying to get DistinctCount from a field if another field in the same table is greater than zero.
I came up with this after I found some help while Googling
PowerPivot DAX -COUNTIF 

DistinctCount_WB:=COUNTROWS(filter(values(factBudgets[RecID]),CALCULATE((COUNTROWS(VALUES(factBudgets[BudgetAmount]))>0))))
The count returned includes all not just values greater than zero. How can I get just values greater than zero?

thx
w