Count of Sales Reps with filter on sales amount


I have a need to get a count of all users in a table where sales are > 0. In my table I have UserName, Sale Date, Sale Amount and Product Type. My initial calculation is as follows:

Users Selling = CALCULATE(
Sales[User Name]),
Sales, Sales[Amount] > “0”))

I receive an error trying to compare Number with Text and suggest using Value or Format. My Amount is formatted as decimal, and my User Name is Text.


Hi Randy. Why do you have the “0”. If the Sales[Amount] column is numeric then you should just use 0 (no inverted commas).


Hi Sam,
That did it, after fixing some source issues that changed the data model.



Great, chrs