topic Re: Divide two columns in a table visual in Power BI in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-two-columns-in-a-table-visual-in-Power-BI/m-p/3917768#M152495 <P>I think it should work if you don't create the calculated column but create a measure instead and put that in the visual.</P> <P>The DAX will be very close to the column DAX but using SUM as an aggregation on each field.</P> Tue, 14 May 2024 15:14:27 GMT HotChilli 2024-05-14T15:14:27Z Divide two columns in a table visual in Power BI https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-two-columns-in-a-table-visual-in-Power-BI/m-p/3917697#M152492 <P>Hello everyone,</P><P>&nbsp;</P><P>I have been struggling with a simple problem. Hopefully I can get help here.</P><P>My data is like this:</P><P><img /></P><P>This is a table visual from the data. I want to have the average value on the Total row to be: 227/920=24.67%, instead of the average value highlighted here.</P><P><img /></P><P>Thank you!</P> Tue, 14 May 2024 14:59:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-two-columns-in-a-table-visual-in-Power-BI/m-p/3917697#M152492 HanaB 2024-05-14T14:59:22Z Re: Divide two columns in a table visual in Power BI https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-two-columns-in-a-table-visual-in-Power-BI/m-p/3917768#M152495 <P>I think it should work if you don't create the calculated column but create a measure instead and put that in the visual.</P> <P>The DAX will be very close to the column DAX but using SUM as an aggregation on each field.</P> Tue, 14 May 2024 15:14:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-two-columns-in-a-table-visual-in-Power-BI/m-p/3917768#M152495 HotChilli 2024-05-14T15:14:27Z Re: Divide two columns in a table visual in Power BI https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-two-columns-in-a-table-visual-in-Power-BI/m-p/3917822#M152500 <P>It worked perfectly. Thank you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 14 May 2024 15:34:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-two-columns-in-a-table-visual-in-Power-BI/m-p/3917822#M152500 HanaB 2024-05-14T15:34:01Z