Forum Discussion
SUM by Person ID
- 7 years ago
you could drop the patients and the Office Visit in a table visual, then drop the measure i posted earlier and the drop this other measure = CALCULATE( SUM( Table[Amount] ), ALL( Table[Office Visit] ) )
Hey Livio,
Thanks! That works--except if I want to see the individual rows that contributed to that total, once I add them back it sums them individually. For example if I had;
Patient A 200 Office Visit
Patient A 100 Labs
Patient B 200 Radiology
Patient B 100 Labs
If I use the sum measure, I'd get;
Patient A 300
Patient B 300
How would I go about this if I wanted to see;
Patient A 200 Office Visit 300
Patient A 100 Labs 300
Patient B 200 Radiology 300
Patient B 100 Labs 300
Or is it best to use a drill down feature? Thanks!
you could drop the patients and the Office Visit in a table visual, then drop the measure i posted earlier and the drop this other measure = CALCULATE( SUM( Table[Amount] ), ALL( Table[Office Visit] ) )