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

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!