Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
NCPowerBI
Helper I
Helper I

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

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!Table.JPG

1 ACCEPTED SOLUTION
TaylorPBI21
Resolver I
Resolver I

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...

TaylorPBI21_0-1677192075311.png

 

Many Thanks,

 

Taylor

 

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

View solution in original post

2 REPLIES 2
NCPowerBI
Helper I
Helper I

This worked perfectly, thanks Taylor!

TaylorPBI21
Resolver I
Resolver I

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...

TaylorPBI21_0-1677192075311.png

 

Many Thanks,

 

Taylor

 

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.