Unable to multiply average measure by a static number

[GaTech5510]

Hello,

I'm not exactly sure of why I am unable to figure this one out, but I've got a column (PS_EAC__c) that I've tried to average and multiply by 135.  When I multiply by 135 it multiplies the overall total for PS_EAC__c and not the average.  In the example below the total PS_EAC__c for this opportunity is 172, but the average is 43 (4 rows for product line items).  I've tried this formula and a couple other methods, but instead of providing 43*135=5805 I receive 172*135=23220.  Am I missing something in the formula?  Thank you in advance for any help that you can provide!

Break Even Amt $135 hr = 
IF(
    HASONEVALUE('Project w Quote Lines'[PS_EAC__c]), 
    SUM('Project w Quote Lines'[PS_EAC__c]) * 135,
    SUMX(
        ALLSELECTED('Project w Quote Lines'[Opportunity__r.SBQQ__PrimaryQuote__r.SBQQ__LineItems__r.SBQQ__ProductName__c]),
        CALCULATE(135*(SUM('Project w Quote Lines'[PS_EAC__c])/COUNT('Project w Quote Lines'[PS_EAC__c]))
    )
))

[v-yadongf-msft · Accepted solution]

Hi @GaTech5510 ,

Please try the following code:

Break Even Amt $135 hr = 
IF(
    HASONEVALUE('Project w Quote Lines'[PS_EAC__c]),
    SUM('Project w Quote Lines'[PS_EAC__c])*135,
    CALCULATE(135*(SUM('Project w Quote Lines'[PS_EAC__c])/COUNT('Project w Quote Lines'[PS_EAC__c]))
        )
    )    

You will receive 43*135=5805, the result you want.

^{Best Regards,}

^{Yadong Fang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[GaTech5510]

@v-yadongf-msft Thank you Yadong!  This worked.  I think I also messed things up by not creating a measure.  I thought I created one initially, but really I created a new column.