Count rows with filter condition

[Anonymous]

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

[Ahmedx]

write like this

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

[Ritaf1983]

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]

that's the column that i want to count how many 2.00, or 3.00 or 4.00 or a 5.00  

[Ritaf1983]

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.

[Anonymous]

this shows the expected results. basically i want the expected results to be dispalyed as  card visual showing a count for each.

[Anonymous]

this shows the expected results. basically i want the expected results to be dispalyed as  card visual showing a count for each.

[Ritaf1983]

Additionally, your original formula works well for the cards. Please see the attached pictures:

It is also possible to combine a basic formula without a filter with filtering the card itself:

test3 = COUNTA('Table'[value])

https://drive.google.com/file/d/1sggfULJW-Dr8sQ80VWUIkrglrBwXWvZy/view?usp=share_link

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

My orginal formula kept giving an error (A circular dependency was detected: 'table1'[cloum1], 'table1'[Column1], 'table1'[column1].)

[Ritaf1983 · Accepted solution]

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.