Forum Discussion
Problems with COUNT
Hi, First post here. This should be simple for an experienced DAX person, and I'd greatly appreciate a suggestion or two. I have a table with weekly stock closing prices for a few thousand tickers. ...
Sure thing! Thanks for the reply!!
Not sure if this will be big enough. If not, let me know.
The screenshot is very small. However please try
Number of Stocks < 200Day MA =
VAR FortyWeekMA = [40-week MA]
RETURN
COUNTROWS ( FILTER ( 'PriceTable', PriceTable[closeadj] < FortyWeekMA ) )
Have you tried above code?
Yes. Thank you, but doesn't seem to work. Must be something in my model that is peculiar.
Please use the variable name inside FILTER same as the code I have shared