Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 c...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

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

     

     

amitchandak's avatar
amitchandak
Super User
3 years ago

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