https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-ratio/m-p/2552288#M72269 <P>Hi,Anonymous</LI-USER>&nbsp;Is this your result?<img /><BR />&nbsp;&nbsp;</P> Wed, 01 Jun 2022 08:32:59 GMT DimaMD 2022-06-01T08:32:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-ratio/m-p/2552248#M72263 <P>Hi everyone, hope you doing well.&nbsp;</P><P>May I know how can I calculate filter based on the example below.&nbsp;</P><P>I want to calculate the percentage of invoice amount that have a contract number.&nbsp;</P><P>For exmaple, picture below shown that 100, 200, 300 have a contract number beside . so the ratio should be&nbsp;&nbsp;100 + 200 + 300 = 600 divide by the total invoice amount 100 + 200 + 300 +100 = 700.&nbsp;</P><P>600/700 = 85%</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>thank you.&nbsp;</P><P>regards</P><P>&nbsp;</P> Wed, 01 Jun 2022 08:14:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-ratio/m-p/2552248#M72263 Anonymous 2022-06-01T08:14:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-ratio/m-p/2552288#M72269 <P>Hi,Anonymous</LI-USER>&nbsp;Is this your result?<img /><BR />&nbsp;&nbsp;</P> Wed, 01 Jun 2022 08:32:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-ratio/m-p/2552288#M72269 DimaMD 2022-06-01T08:32:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-ratio/m-p/2552355#M72275 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="312820" data-lia-user-login="DimaMD" class="lia-mention lia-mention-user">DimaMD</a>&nbsp;,</P><P>yes ! thank you so much !</P> Wed, 01 Jun 2022 08:52:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-ratio/m-p/2552355#M72275 Anonymous 2022-06-01T08:52:12Z