Count of Sales Reps with filter on sales amount


#1

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(
DISTINCTCOUNT(
Sales[User Name]),
FILTER(
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.


#2

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


#3

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

Thanks


#4

Great, chrs