This is more of an "Is this possible in PowerPivot" than an emergency or whatever...
I have a table in my database that describes symptoms that a patient experiences, and they're graded by severity (1 to 5). When I do the reporting, they only want to know about the highest grade symptom per (patient, symptom). In T-SQL, this is stupid easy... it's just a totals query.
GROUP BY PatientID
My question is this... assuming I can't write my own queries (because I don't have rights on the SQL Server), how do I write something like this in DAX? (I was looking at ADDCOLUMNS etc, but that mess just boggled my mind!!!)
If it's in one of the books on DAX, which one? I have all of them except Matt Allington's book.
Here's the basic structure of the Symptoms table...
CREATE TABLE PatientSymptoms (
,Grade TINYINT NOT NULL
,Cycle TINYINT -- surrogate for DATE
CONSTRAINT pkPatientSymptoms PRIMARY KEY (EnrolleeID, SymptomID, Cycle) )
The Symptom names are in another table...
--- I'm just wondering how to get my head around doing the summaries (totals queries) in DAX instead of T-SQL... I know I can use the SQL window in PowerBI and/or Excel, but I was wondering if there were another way.