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 t...
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])) }



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: