How to get sum of Values group by Patient ID

[mohit19]

I have a "Date", "Value", "Patient ID" column now i want to create a measure that show sum of "Value"  group by "Patient ID". I want to use it in HeatMap Custom Visual.

[Phil_Seamark · Accepted solution]

HI @mohit19

A basic calculated measure could be

Sum of Value = SUM('Table1'[Value])

Simply drag that to a visual on your canvas along with the PatentID field, and the visual should display what you want.