Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
i created a table with 3 measures. Here same code works.It doesnt work in the switch function
Hello there @marial16 ! Are you using the DIVIDE() function? If so, how are you hanling errors?
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....
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |