Forum Discussion

AgeOfEgos's avatar
AgeOfEgos
Icon for Helper I rankHelper I
7 years ago
Solved

SUM by Person ID

I have a table that will have multiple rows per Person ID that I would like to sum and then filter.  For example;   Patient A                90 Patient A              100 Patient A               ...
  • LivioLanzo's avatar
    LivioLanzo
    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] ) )