DAX - Queries don run

[Markzolotoy]

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

[Fowmy · Accepted solution]

@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]

@Markzolotoy 

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

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

[Markzolotoy]

@Fowmy This is for real data:

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

result: