DAX how to count number of rows with a value

[jenniferhoward]

I have a table similar where I need to count up number (by month) of rows that have Y value in them.  I tried below but it is not returning values at all.  I am able to count rows but I need to count only the Y rows.   What do I have wrong?

#Y = COUNTROWS(filter(TABLE,TABLE[OverThres]="y"))

thanks!

date	over threshold	amount
1/1/2023	y	5,000.00
1/2/2023	n	-
1/3/2023	y	2,000.00
1/4/2023	y	6,000.00
1/5/2023	n	100.00

[Greg_Deckler · Accepted solution]

@jenniferhoward Is your column named "over threshold" or "OverThres"? You might try:

#Y = COUNTROWS(FILTER(ALL('Table'),[over threshold] = "y"))

Also, make sure you don't have any non-printing characters or anything in your over threshold column. (Trim and Clean in Power Query)

[jenniferhoward]

thanks so much, formula worked!