cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RK_JOB
Helper II
Helper II

Multiplication issue

Hello,

I am running into a situation where I want to multiply a column with a measure.

Little background:

1. I have data in local currency. I am multiplying it by a conversion factor. I get this conversion factor based off of the latest value of the slicer selected.

2. Now when I put the conversion exchange rate in the table then it calculates it correctly as in Table 1.

3. But if I remove the Conversion Exchange Rate from the table then I get very big value as shown in table 2. I understand it is multiplying based on this formula:

AVG - Jan 1st EE Avg. Salary DOLLARS M =
'Wage Inflation Measures'[AVG - Jan 1st EE Avg. Salary Loc. Currency M]*HRIS_MD_EXCHANGE_RATES[Conversion Exchange Rate M]

4. How do I force it to use the single conversion rate (in this case .2596) without having that in the table?

 

RK_JOB_0-1667881729065.png

 

pbix: https://drive.google.com/file/d/1Gc1JXF_AVR9SeCZk7CgXMQUurHx1CWB6/view?usp=share_link

 

 

Thanks in advance,

EZ

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@RK_JOB , Multiplication should be done at row level or some grouping , Assuming Conversion Exchange Rate M is also a measure 

 

example

 

AVG - Jan 1st EE Avg. Salary DOLLARS M =
Sumx(Employee, 'Wage Inflation Measures'[AVG - Jan 1st EE Avg. Salary Loc. Currency M]*HRIS_MD_EXCHANGE_RATES[Conversion Exchange Rate M])


AVG - Jan 1st EE Avg. Salary DOLLARS M =
Sumx(values(Employee[Manager Level]), 'Wage Inflation Measures'[AVG - Jan 1st EE Avg. Salary Loc. Currency M]*HRIS_MD_EXCHANGE_RATES[Conversion Exchange Rate M])

 

 

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

Hi @RK_JOB ,

 

Whether the advice given by @amitchandak has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry

amitchandak
Super User
Super User

@RK_JOB , Multiplication should be done at row level or some grouping , Assuming Conversion Exchange Rate M is also a measure 

 

example

 

AVG - Jan 1st EE Avg. Salary DOLLARS M =
Sumx(Employee, 'Wage Inflation Measures'[AVG - Jan 1st EE Avg. Salary Loc. Currency M]*HRIS_MD_EXCHANGE_RATES[Conversion Exchange Rate M])


AVG - Jan 1st EE Avg. Salary DOLLARS M =
Sumx(values(Employee[Manager Level]), 'Wage Inflation Measures'[AVG - Jan 1st EE Avg. Salary Loc. Currency M]*HRIS_MD_EXCHANGE_RATES[Conversion Exchange Rate M])

 

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.