Need help with a simple formula / measure

DLamarche 

pity the result from PBI isn’t correct: you would be very rich!

try this:

Sales Amount = SUMX(tblCalls,  SUM(tblCalls[CallLength]) * SUM(tblCalls[CallRateApplied])).

Hi Daniel,

use the following measure:

=SUMX(tblCalls, tblCalls[CallLength] * tblCalls[CallRateApplied])

The function SUMX() iterates through the table tblCalls and row by row it multiplies CallLength by CallRateApplied. At the end it sums up all computed multiplications.

FrankAT

Thanks to both of you guys. One day I promise that when I'll be better at that stuff I will return the favour (Aussie spelling).

I have to look more in depth ... again ... about the SUMX() function.

Thanks a bunch again.   8-)