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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jay2077
Helper III
Helper III

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 

 

Jay2077_0-1620904222795.png

Jay2077_1-1620904331022.png

 

Any help greatly appreciated 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

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

View solution in original post

5 REPLIES 5
HashamNiaz
Solution Sage
Solution Sage

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

Thank you

amitchandak
Super User
Super User

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

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

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 ?

 

Thank you

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors