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. ...
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
Replied to above
Sorry. Here it is:
Would you please add the moving average measure and snother measure: COUNTROWS ( 'PriceTable')
