DAX Calculate SUM Help

[mcornfield]

I am Trying to Get a SUM of a COunt of Customer Names. They are not summing.

[AlexisOlson]

You can iterate over each of the customers like this:

SUMX (
    VALUES ( Table[CustomerName] ),
    IF ( [Customer Total] > 0, 1, 0 )
)

[MFelix · Accepted solution]

Hi @mcornfield ,

Try the following code:

Count = COUNTROWS ( FILTER(SUMMARIZE(Table,Table[CustomerName], "Customer Total", [Customer Tolal]),[Customer Total] > 0 ))