Forum Discussion
Measure Not Calculating Totals
I have a Measure that identifies pts with a significant wt loss. It works correctly row by row, however. I need the total rows and the total number of distinct patients. MEASURE 1 (works as i...
Please try this measure expression instead. It references your existing (working) measure. You should get a count of 1 for each patient that meets the criteria.
30dWtLoss Distinct Pts =
SUMX(SUMMARIZE(MSTR_Patient, MSTR_Patient[PatientID]), [30d SignWtLoss])
Regards,
Pat
It totals row by row this way, but my column total is 0. Is there something else I need to add?