Division of two variables

[marial16]

Hallo,

i am facing an issue trying to divide the values of two variables.

I have created a table with Measures for calculations and i initiate a number of variables.

Because i am using different lists i have a common LookUp field and they are connected.

At some point i have to divide two values. It does not seem to work (while adding the values worked for example)

I have tried Divide(val10a,val1) and even val10a/val1.

VAR Val1 = Calculate(Sum(MyList[OS]),Filter......)

VAR Val10a = COUNTROWS(FILTER(MyOtherList,List[CategoryID]=1.......)

I have tried to write Val10a as Calculate(COUNTROWS(....

or VALUE(COUNTRows(...

For some reason i am getting blank or the calculation is not happening . Any ideas?

[marial16]

i created a table with 3 measures. Here same code works.It doesnt work in the switch function

[goncalogeraldes]

Hello there @marial16 ! Are you using the DIVIDE() function? If so, how are you hanling errors?

[marial16]

yes i tried using the devide function but to see if it works i set the values to be 

VAR Val1 =2 

VAR Val10a = 2

which would have to return 1 ,but it does not.

in the sequence of my code in the Measure i use..

RETURN

SWITCH (SELECTEDVALUE(ReportList[ListID]),

1, If(ISNUMBER(Val), Val , 0,

2....