Forum Discussion
Multiply columns
I need to multiply 2 different columns; hours and rate per hour. The issue here is that I have different rates for different ranks and each project is the sum of the multiplication of hours at different rates.
I have achieved to calculate the total price when I show the maximum detail.
E.g. R1 x hours
R2 x hours
R3 x hours
With the code
Valorizado = SUMX(ARMS,ARMS[total]) * SUMX(PL,PL[Person Billing Rate])
Where ARMS are the hours per project.
This works fine when I show the whole detail, but when I want to show only the information by project, what the code understands is the following:
Sum( R1 +R2+R3) x Sum(hours)
Please I need help with this!
Hi gbarredap,
If I understand you correctly, there is a relationship between ARMS and PL, to calculate multiplication then add total, you can create a measure in PL table like below:
Measure 2 = SUMX('PL',PL[Person Billing Rate]*RELATED(ARMS[total]))
If the above measure doesn't work, please share some sample data and expected results for our analysis.
Best Regards,
Qiuyun Yu
2 Replies
Hi gbarredap,
If I understand you correctly, there is a relationship between ARMS and PL, to calculate multiplication then add total, you can create a measure in PL table like below:
Measure 2 = SUMX('PL',PL[Person Billing Rate]*RELATED(ARMS[total]))
If the above measure doesn't work, please share some sample data and expected results for our analysis.
Best Regards,
Qiuyun Yu
Hi gbarredap
Could please share your data model and the expected output to find a solution.
Cheers
CheenuSing
