DAX error in PBI

[Anonymous]

Hi, I am getting an error with this DAX formula:

        Number of NW Accounts = CALCULATE(SUM('Table1'[CustomerName]),'Table2'[Region]="Northwest")

The error msg is this:

        "Calculation error in measure: The function SUM cannot work with values of type String"

[lbendlin · Accepted solution]

Then you want to swap SUM for COUNT.

[lbendlin]

Correct.  You can't really add up customer names.  What were you trying to achieve?

[Anonymous]

The number of customers. There is no customer id, so I thought to use the 'Name' field to count the number of customers. Thanks.

[lbendlin · Accepted solution]

Then you want to swap SUM for COUNT.

[Anonymous]

Thanks. I forgot.

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

You can also use "COUNTROWS",is your issue solved?If so,could you mark the reply as answered to close it?

Much appreciated.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Thank you!