Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX error in PBI

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 ...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    Then you want to swap SUM for COUNT.

  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
lbendlin
Super User
6 years ago

Then you want to swap SUM for COUNT.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks. I forgot.

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

        Thank you!