https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Change-iferror-to-percentage/m-p/3834659#M9452 <P>In excel, I have a formula that is =1-(2/12) as an example. In Power BI key measures I have this formula set to an iferror statement due to an issue if some of my data has 0 as the value.&nbsp;</P><P><BR />The dax code is now IFERROR([Numerator]/[denominator], 0)</P><P>&nbsp;</P><P>However, it is now not showing as a correct %. For example the excel formula is showing as 83.33% and the dax formula is now 16.67% and for the life of me, I cannot figure out how to subtract 100 from the 16.67% to make 83.33%. Any help would be greatly appreciated!&nbsp;</P> Fri, 12 Apr 2024 18:49:48 GMT Courtb86 2024-04-12T18:49:48Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Change-iferror-to-percentage/m-p/3834659#M9452 <P>In excel, I have a formula that is =1-(2/12) as an example. In Power BI key measures I have this formula set to an iferror statement due to an issue if some of my data has 0 as the value.&nbsp;</P><P><BR />The dax code is now IFERROR([Numerator]/[denominator], 0)</P><P>&nbsp;</P><P>However, it is now not showing as a correct %. For example the excel formula is showing as 83.33% and the dax formula is now 16.67% and for the life of me, I cannot figure out how to subtract 100 from the 16.67% to make 83.33%. Any help would be greatly appreciated!&nbsp;</P> Fri, 12 Apr 2024 18:49:48 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Change-iferror-to-percentage/m-p/3834659#M9452 Courtb86 2024-04-12T18:49:48Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Change-iferror-to-percentage/m-p/3834925#M9454 <P>No need for IFERROR.</P> <P>&nbsp;</P> <P>use DIVIDE(<SPAN>[Numerator],[Denominator], 0)</SPAN></P> Sat, 13 Apr 2024 00:32:50 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Change-iferror-to-percentage/m-p/3834925#M9454 lbendlin 2024-04-13T00:32:50Z