Forum Discussion

AlanMB's avatar
AlanMB
New Member
1 year ago

Emulating Excel CountIfs

Hi - I am realy struggling with this, have seen a number of posts that almost solve it but I just can't get it to work. Difficult to explain why I need this without writing an entire essay, but belo...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi AlanMB ,hello Greg_Deckler, thank you for your prompt reply!


The second argument to the CALCULATE function should be a logical condition, not a table name.


Please try the following dax:

IVRCount = 
CALCULATE (
    COUNTROWS ( AB_Partner_Report ),
    AB_Partner_Report[queue] = "IVR", 
    AB_Partner_Report[networkConnIDAB] = AB_Partner_Report[networkConnIDAB]  
)

 

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • AlanMB's avatar
    AlanMB
    New Member
    1 year ago

    Hi  v-yajiewan-msft

    I still get the message ""Expression.Error: The name 'CALCULATE' wasn't recognized. Make sure it's spelled correctly."

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi AlanMB,


      Ensure you're not using CALCULATE in the Power Query Editor. 

      CALCULATE is a DAX function and should be used in calculated columns or measures within the Data Model, not in Power Query (which uses M language).

       

      Best regards,

      Joyce

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.