Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

DAX - Queries don run

I am learning DAX by reading "The definitive Guide to DAX". So I am typing in the following command:

COUNTROWS(VALUES('TABLENAME'[COLUMNNAME]) and get that query completed with errors. CAn someone tell what the problem is?

 

Thanks

 

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Markzolotoy 

    I believe you are using DAX Studio,. To run a measure, wrap it in curly brackets:

    EVALUATE
    {  COUNTROWS(VALUES('test_ptsd'[payor_name])) }



3 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    Markzolotoy 

    Missing the last bracket. Make sure you are creating a New Measure

    COUNTROWS( VALUES('TABLENAME'[COLUMNNAME]) )

     

    • Markzolotoy's avatar
      Markzolotoy
      Icon for Impactful Individual rankImpactful Individual
      5 years ago

      Fowmy This is for real data:

       COUNTROWS(VALUES('test_ptsd'[payor_name]))

      result:

       

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    Markzolotoy 

    I believe you are using DAX Studio,. To run a measure, wrap it in curly brackets:

    EVALUATE
    {  COUNTROWS(VALUES('test_ptsd'[payor_name])) }