Divide function changes value

[Anonymous]

When I use the following measure it shows correct value, 1.50 (the same value in table from where I read data )

Measure1:=  
                 LOOKUPVALUE('Table1'[column1]
               ,'Table1'[Value]
               ,"NameOfValue"
               ,'Table1'[Parameter],"report1") 

the result of this measure is 1.50 ; But when I divide it by -1 the result is changed to -0.05.

Measure1:=  DIVIDE(
                 LOOKUPVALUE('Table1'[column1]
               ,'Table1'[Value]
               ,"NameOfValue"
               ,'Table1'[Parameter],"report1") 
               ,-1)

I even tried multiplication(* -1) but getting the same result , -0.05

How should I change the measure to get -1.50?

[Wendeley-North]

Seems to be an issue with your parentheses.

Measure1=  
VAR value = LOOKUPVALUE('Table1'[column1]
                        ,'Table1'[Value]
                        ,"NameOfValue"
                        ,'Table1'[Parameter],"report1")
RETURN
    DIVIDE ( value, -1 )
            

[Anonymous]

I changed as you suggested but still getting the same result, it returns -0.05.

[v-deddai1-msft]

Hi @Anonymous ,

What's the data type of your [column1]?  What's your data source? All thing works well based on my test. Would you please show us some sample data that could the issue?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Wendeley-North]

Could you show a table with the two measures inside showing -1.50 and -0.05? Also, could you upload some sample data?