how to multiply column with measure

[pokarman]

In the above snip i am trying to multiply GR QTY column with measure actualval and displaying result in other measure Actualvalsaleafterpercentage but i m calcuating same value in calculator is coming different . how to get same value in powerbi .below formula i have used 

[actualval]*[Quantity]

Please let me know 

[v-lid-msft]

Hi @pokarman ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @pokarman ,

What is the reason you choose to use the Value function, As far as I'm concerned, this function is purpose to Convert a text string that represents a number to a number. What is the return type of the measures [Quantity] and [actualval] and could you please share the folmula of those measures if it does not contain any confidential information? Have you tried to just ues ActualvalSaleafterpercentage = [Quantity] * [actualval] if those measure just return number?

Or we can use the following measure to force them calculated as 2-dial decimal number:

ActualvalSaleafterpercentage = Rounddown([Quantity],2) * Rounddown([actualval],2)

Best regards,

[Greg_Deckler]

Is it possible that your actualVal measure has more decimal places than you are showing? For example, if the actualVal in your first row is actually 1.441990384 then that would explain it.

[pokarman]

@Greg_Deckler  Hello Greg , 

I am showing exact 2 decimal places but still result is not showing correct.

[Greg_Deckler]

OK, and I don't mean to needle but did you try increasing how many decimal places are shown by using the formatting ribbon? I have to ask to be sure because it's the only thing that makes sense.