Count occurrences in table visual

[astano05]

I'm looking to count the number of occurences in a table. I have 2 table visuals filtered for over Standard Devition of X and under X. 

I want to count the number of occurences, but using calculate(count([NAME]),[Standard Deviation]>X) i get the following error:

A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

Is it possible to fix this, or is there a way to get the count of a non-numerical field in the Total section of a table visual.

[amitchandak · Accepted solution]

@astano05 , you have try like this

calculate(count([NAME]),filter(Table,[Standard Deviation]>X))

[astano05]

@amitchandak  Thanks for responding! I tried that and got this error: A circular dependency was detected: Data Block[Column]. (Data Block is the name of the table). 

I'm not sure what the circular dependancy would be. The standard deviation measure does not use the name column.

[Anonymous]

Hi @astano05 ，

What's in your measure of standard deviation?Try below meausre :

countx(filter(Table,[Standard Deviation]>X),[NAME])

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!