Forum Discussion

Jay2077's avatar
Jay2077
Helper III
5 years ago
Solved

DAX New Measure Calculation Help

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 

 

  • amitchandak's avatar
    amitchandak
    5 years ago

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

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

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

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

    • Jay2077's avatar
      Jay2077
      Helper III
      5 years ago

      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 ?

       

  • HashamNiaz's avatar
    HashamNiaz
    Solution Sage
    5 years ago

    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