DAX New Measure Calculation Help

[Jay2077]

Hi, I am trying to write a simple new measure calculation for this test report 

I have 2 tables like below, code refers to an album 

I just want to do something like albumlength = calculate(sum(album title Abbey Rd 

etc 

Any help greatly appreciated 

[HashamNiaz]

Hi !

You can solve this by proper Data Modelling. 

You can create a 1-Many relationship between [Album] & [Songs] table based on [Code] column.

Now you can simply, create a measure to calculate sum of lenght like below;

Album Lenght = SUM(Song[Lenght])

This will simple give you Total Length of Album if you plot a chart against Album.

Regards,

Hasham

[Jay2077]

Thank you

[amitchandak · Accepted solution]

@Jay2077 , based on what I got a measure like this should do

calculate(sum(Table1[length]), filter(Table1,Table1[song title] = "Abbey Rd"))

[Jay2077]

Can't get this working 

if the top table is called Sheet 1 and the 2nd is called year how would i write your code ?

[Jay2077]

Thank you