Count of Sales Reps with filter on sales amount

DAX DAX Calculations
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