Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@Jay2077 , based on what I got a measure like this should do
calculate(sum(Table1[length]), filter(Table1,Table1[song title] = "Abbey Rd"))
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
@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
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |