cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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?

EZ

1 ACCEPTED SOLUTION
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])

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

Best Regards,
Henry

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])

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors