https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Power-Query-DAX-Formula/m-p/4207958#M166833 <P>I've looked this one up and know it will be some sort of divide function, but I am having trouble getting a measure to fit in when writing&nbsp;it. Below I would need each instance of the row labels in the Bridge Column divided by the total actuals (2.1) in a percentage. Once again, I assume this is easier than it appears, but I cannot get the formula to work for me. Thanks!</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 01 Oct 2024 12:07:21 GMT Anonymous 2024-10-01T12:07:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Power-Query-DAX-Formula/m-p/4207958#M166833 <P>I've looked this one up and know it will be some sort of divide function, but I am having trouble getting a measure to fit in when writing&nbsp;it. Below I would need each instance of the row labels in the Bridge Column divided by the total actuals (2.1) in a percentage. Once again, I assume this is easier than it appears, but I cannot get the formula to work for me. Thanks!</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 01 Oct 2024 12:07:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Power-Query-DAX-Formula/m-p/4207958#M166833 Anonymous 2024-10-01T12:07:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Power-Query-DAX-Formula/m-p/4209051#M166906 <P>Anonymous</LI-USER>&nbsp;, Try using below DAX</P> <P>&nbsp;</P> <P>Percentage of Total = <BR />DIVIDE(<BR />SUM('YourTable'[Bridge Column]),<BR />CALCULATE(SUM('YourTable'[Bridge Column]), ALL('YourTable'))<BR />) * 100</P> Tue, 01 Oct 2024 14:58:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Power-Query-DAX-Formula/m-p/4209051#M166906 bhanu_gautam 2024-10-01T14:58:58Z