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!
lbendlin's avatar
lbendlin
Icon for Super User rankSuper 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
    Icon for Community Support rankCommunity 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!