Sum of Value by Distinct Member Id

[Vamshi2020]

Hi All,

I have a Table with few columns such as member id, start date, end date , provider name etc, value etc...my value column is a calculated column with value=1 formula. so this column contains 1 for all rows. 

Requirement is to calculate "sum of value for distinct member id ". Please help me to achieve this .

TIA

[amitchandak · Accepted solution]

@Vamshi2020 , Try a measure like

sumx(values(Table[member id]), calculate(max(Table[Value])))