need help to write a formula to count a specific number that is repeated and showing up in a column

[afarbod]

I have a table that looks like this, below, the column ORder shows numbers.  What I am interested in is to write a formula to look in the Order column and count the number of times the number "4" appears.   

Customer	Description	Order
A	Logs pulled	7
B	Partial logs	4
C	Partial at 8- %	4
d	No Logs	3

[Ritaf1983 · Accepted solution]

Hi @afarbod 

Try a measure :

count_4 = CALCULATE(COUNTROWS('Table'),'Table'[Order]=4)

pbix is attached 

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

[afarbod · Accepted solution]

Thank you so much for your quick response.   for some reason, I keep getting 1 for the result, not sure if that has something to do with my table below

my formula  : 

return new account value = CALCULATE(COUNTROWS('Table_enumLogStatus'), Table_enumLogStatus[Order]=4)

I keep getting 

[Ritaf1983 · Accepted solution]

Hi @afarbod 

Try a measure :

count_4 = CALCULATE(COUNTROWS('Table'),'Table'[Order]=4)

pbix is attached 

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

[afarbod · Accepted solution]

Thank you so much for your quick response.   for some reason, I keep getting 1 for the result, not sure if that has something to do with my table below

my formula  : 

return new account value = CALCULATE(COUNTROWS('Table_enumLogStatus'), Table_enumLogStatus[Order]=4)

I keep getting 

[Ritaf1983]

Hi @afarbod 
Please share a link to dummy pbix and I'll try to help

[afarbod]

Thank you again, I think I figured out what I was doing wrong, I used your formula and worked.   Thank you so much

[Ritaf1983 · Accepted solution]

Glad to help @afarbod ☺️

please consider Accepting my post as the solution to help the other members find it more quickly.