How to obtain RecordCount (or Number of cases) from a DMX query
This one caught my eye on the Data Mining Forum and it is not the first time that this one has cropped up.
The question
"Hello
I have a DMX listed below. Now if i run this in the Sql Server Management Studio, it returns me the list of Customers that meet the specified criteria (in the Where clause, PredictProbability(Response) > 0.6) ). I would like to just get the count of customers who meet this criteria, dont need the actual Customer records. Since we dont have the equivalent of COUNT(*) in DMX, how would you go about doing this.
Tags: data mining