need help in creating measure

[sunilnarayan]

I have a dataset with multiple columns: Country, Age Group, Type, Person, Number of Days, and Rating.

I want to create a measure called Total_Duration, which will be the sum of the maximum value for each Type.

Need to create measure of red highlighted columns. Sample data link is given below.

https://docs.google.com/spreadsheets/d/1ax-q5CRYXGttZtlRLYB5anibWdSuE9ex/edit?usp=drive_link&ouid=11... 

[lbendlin · Accepted solution]