Multiply measure with a cloumn

[Anonymous]

Hi all,

This is related to if there is a way to multiple value of  a measure to a column. I have cost in either euor or pound and I want all of them to be converted into pound. First I have to divide cost by a million and then multiply by currency rate. And I have currency rate coming from database for each row. 

If I create currency rate as a measure then results are wrong. So I had to create a calculated column with all of the calulations and then create a measure which is equal to sum(calculated column). But I am looking for a better and effective way to do it.  

[Greg_Deckler]

Sample data and formulas please.

[Anonymous]

@Greg_Deckler

Here is the sample dataset 

[v-xjiin-msft]

Hi @Anonymous,

Did you mean this?

Measure:

Final Cost =
CALCULATE ( MAX ( Tab[cost] ) ) / 1000000
    * CALCULATE ( MAX ( Tab[currency_rate] ) )

Thanks,
Xi Jin.

[afzalphatan]

Simple one... hope the solution is marked....

[Anonymous]

@v-xjiin-msft

Why did you use MAX in the calculation? When I tried using this formula in my original dataset I din't get the desired results. 

[v-xjiin-msft]

Hi @Anonymous,

Because I'm using a measure. Measure cannot call the table column directly. 

As you said it didn't work for you. Could you please share us some detailed screenshots about your wrong results?

Thanks,
Xi Jin.

[Anonymous]

@v-xjiin-msft

 I should be geteing same values a spend column rather I am getting values in final cost

[v-xjiin-msft]

Hi @Anonymous,

Sorry but I don't quite understand about your screenshot and your description.

Sicne the finalcost formula is Adjusted Cost/Currency Rate and the formula of Adjusted Cost is Cost (Spend ?)/1000000. So the final formula shoule be Cost (Spend ?)/1000000/Currency Rate. Right?

Then what does "getting same values as spend column"?

Thanks,
Xi Jin.