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. ...
Hi elandry9840
how does your report look like? Can you share a screenshot of your data model?
Sure thing! Thanks for the reply!!
Not sure if this will be big enough. If not, let me know.
This is better:
Best:
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.