Multiply columns

[gbarredap]

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!

[v-qiuyu-msft · Accepted solution]

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

[CheenuSing]

Hi @gbarredap

Could please share your data model and the expected output to find a solution.

Cheers

CheenuSing