Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Vamshi2020
Helper II
Helper II

Sum of Value by Distinct Member Id

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Vamshi2020 , Try a measure like

 

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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Vamshi2020 , Try a measure like

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.