how to divide by 2 the sum of two results from different columns multiply each by different weights

[Anonymous]

I have two results from different tables columns and I want to multiply each with different weights add them together and divide them by 2. 

here is an example of what I want to do 

//Strategy Party Satisfaction = divide(SUM(partySatisfaction[ % Interested party satisfaction ]*0.3,Sum(nonConformanceItem[ % Non conformance report completed on time]*0.7;2;0)

[Anonymous]

this is worked great just we need to replace the semicolon with a comma. thank you for your help

Regards,

[jdbuchanan71]

Ah, I used ; jsut becasue you had them in your original post and I thought it might be a regional thing.  I have udpated my reply and marked it as the solution.

[jdbuchanan71]

@Anonymous 

Not really sure where the problem is coming from.  I would have to see your data model to help further.  Please post your .pbix to dropbox or onedrive and share the link here.

[Anonymous]

thank you for the quick response. I tried your formula and I got the below error. please check

[jdbuchanan71 · Accepted solution]

@Anonymous 

Give this a try 

Strategy Party Satisfaction =
DIVIDE (
    SUM ( partySatisfaction[ % Interested party satisfaction] ) * 0.3 + 
    SUM ( nonConformanceItem[ % Non conformance report completed on time] ) * 0.7,
    2,
    0
)

[Anonymous]

Here is what I needed to do. Add the two gauges result and multiply it by the weight. I tried the following but I got the wrong result. the result should show 85.77% but the result here shows 257.34%

test = (Sum(partySatisfaction[ % Interested party satisfaction ]) *0.3) +

SUM(nonConformanceItem[ % Non conformance report completed on time]) *0.7