https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-Divide-Two-Variables/m-p/3443604#M130880 <P>Hello, I have been attempting to create a percentage based off two variables, both of the variables can be added to the return function and will accurately show their value, but when I attempt to divide them it will only output is the errorRows variable as the result?&nbsp;<BR />Column</P><P><img /></P><P>Which results in&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Result when return is set to just allRows</P><P><img /></P><P>then just error rows</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 22 Sep 2023 17:32:53 GMT Asuna 2023-09-22T17:32:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-Divide-Two-Variables/m-p/3443604#M130880 <P>Hello, I have been attempting to create a percentage based off two variables, both of the variables can be added to the return function and will accurately show their value, but when I attempt to divide them it will only output is the errorRows variable as the result?&nbsp;<BR />Column</P><P><img /></P><P>Which results in&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Result when return is set to just allRows</P><P><img /></P><P>then just error rows</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 22 Sep 2023 17:32:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-Divide-Two-Variables/m-p/3443604#M130880 Asuna 2023-09-22T17:32:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-Divide-Two-Variables/m-p/3443694#M130884 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="554983" data-lia-user-login="Asuna" class="lia-mention lia-mention-user">Asuna</a>&nbsp;</P> <P>are you sure that you have created a measure not a calculated column?</P> Fri, 22 Sep 2023 18:54:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-Divide-Two-Variables/m-p/3443694#M130884 tamerj1 2023-09-22T18:54:04Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-Divide-Two-Variables/m-p/3443698#M130885 <P>Ah sorry I am an idiot apologies, I am quite new to power bi haha&nbsp;</P> Fri, 22 Sep 2023 19:02:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-Divide-Two-Variables/m-p/3443698#M130885 Asuna 2023-09-22T19:02:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-Divide-Two-Variables/m-p/3443700#M130886 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="554983" data-lia-user-login="Asuna" class="lia-mention lia-mention-user">Asuna</a>&nbsp;</P> <P>It happens even with experts. That is totally normal.&nbsp;</P> Fri, 22 Sep 2023 19:04:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-Divide-Two-Variables/m-p/3443700#M130886 tamerj1 2023-09-22T19:04:10Z