Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Count rows with filter condition

I am trying to create a measure volumn based on this syntaxt but getting an error saying there is a cicurlar dependency

Count_A = calculate(COUNTA('mytable'[column1]),'mytable'[column1] =1.00). Does anyone know where i might be going wrong?

column1 has values between 1 and 5 and the requirement is to count how rows of 1, 2, 3, 4, 5

Ritaf1983
3 years ago
Please download my file from the last answer and compare what we did.
Please share your file if it still fails to work.
This is a link:
https://drive.google.com/file/d/1sggfULJW-Dr8sQ80VWUIkrglrBwXWvZy/view
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

9 Replies

Ritaf1983
Super User
3 years ago
Hi Anonymous
In terms of syntax, it is correct.
Attached is a picture of what I tried.
Regarding logic, I'm not sure I understand what you're trying to accomplish.
Could you please attach a sample of your data and the desired result?
- Anonymous
  Not applicable
  3 years ago
  that's the column that i want to count how many 2.00, or 3.00 or 4.00 or a 5.00
  - Ritaf1983
    Super User
    3 years ago
    The picture is cropped and still difficult to understand something.
    Please attach a table / link to your file, as well as a picture of the desired result.

Super User

write like this

Count_A = calculate(COUNTA('mytable'[column1]),
FILTER(ALL('mytable'),'mytable'[column1] =1.00))

Related content