Level of detail multiplication and division on each row that rolls up to an aggregated number

[NCPowerBI]

Hi all,

I'm new to Power BI and I'm trying to figure out the DAX formula to perform multiplication on each row for two columns (see attached screenshot: Cur_Rate * Curr Amt Fin / 100). I want each row to calculate so it rolls up into an aggregated number. Let me know your thoughts on the formula!

[NCPowerBI]

This worked perfectly, thanks Taylor!

[TaylorPBI21 · Accepted solution]

Hi @NCPowerBI ,

Try this measure...😎

New Measure = 
VAR A = SUMX('Table A', ('Table A'[Cur Rate] * 'Table A'[Curr Amt Finn]))
VAR B = A / 100
Return B

Here is an example of it working...

Many Thanks,

Taylor

LinkedIn: www.linkedin.com/in/taylordownes10 😊