https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3831591#M1237405 <P>Thank you, I am having difficulty getting a measure to work. I have two tables one with items and profi percent and another table with the sale items and then sales measures to work out the total of the total goods sold</P> Thu, 11 Apr 2024 18:04:34 GMT pb14 2024-04-11T18:04:34Z https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3827660#M1236640 <P>Hi, I am new to Power Bi and have been trying to learn DAX etc. I have a table that I needs a measure and I am having difficulty, so I thought I would try the new calculation in tables and I am still having difficulty. I have three columns and I need to find the profit percent of the sales column</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Wed, 10 Apr 2024 13:30:15 GMT https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3827660#M1236640 pb14 2024-04-10T13:30:15Z https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3827748#M1236655 <P>Hello! For profit percent you really should have the COGS that way profit and profit percent can be calculated through a measure. With what you have right now you wouldn't be able to calculate it - you would just be able to take an average of the percentages that you have, but not come to a true amount for anything except at the row level like it is now.</P> Wed, 10 Apr 2024 13:58:22 GMT https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3827748#M1236655 audreygerred 2024-04-10T13:58:22Z https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3831591#M1237405 <P>Thank you, I am having difficulty getting a measure to work. I have two tables one with items and profi percent and another table with the sale items and then sales measures to work out the total of the total goods sold</P> Thu, 11 Apr 2024 18:04:34 GMT https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3831591#M1237405 pb14 2024-04-11T18:04:34Z https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3837615#M1238696 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="622073" data-lia-user-login="audreygerred" class="lia-mention lia-mention-user">audreygerred</a>&nbsp;, thanks for your concern about this case.</P> <P>&nbsp;</P> <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="496848" data-lia-user-login="pb14" class="lia-mention lia-mention-user">pb14</a>&nbsp;</P> <P>&nbsp;</P> <P>Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Jayleny</P> <P>&nbsp;</P> <P>If this post&nbsp;<STRONG><EM>helps</EM></STRONG>, then please consider&nbsp;<STRONG><EM>Accept it as the solution</EM></STRONG>&nbsp;to help the other members find it more quickly.</P> Mon, 15 Apr 2024 08:52:19 GMT https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3837615#M1238696 Anonymous 2024-04-15T08:52:19Z https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3840095#M1239231 <P>Hi these are the results I would be looking for, thank you for your help</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 16 Apr 2024 06:05:16 GMT https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3840095#M1239231 pb14 2024-04-16T06:05:16Z https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3840255#M1239270 <P><FONT>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="496848" data-lia-user-login="pb14" class="lia-mention lia-mention-user">pb14</a></FONT>&nbsp;</P> <P>&nbsp;</P> <P>You mean the column "Percent Total" is the result you want, right?</P> <P>&nbsp;</P> <P>Plesse try the following measure:</P> <LI-CODE lang="markup">Percent Total = Max('Table'[Sales]) * Max('Table'[Precent])</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Jayleny</P> <P>&nbsp;</P> <P>If this post&nbsp;<STRONG><EM>helps</EM></STRONG>, then please consider&nbsp;<STRONG><EM>Accept it as the solution</EM></STRONG>&nbsp;to help the other members find it more quickly.</P> Tue, 16 Apr 2024 07:06:09 GMT https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3840255#M1239270 Anonymous 2024-04-16T07:06:09Z https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3840272#M1239275 <P>Yes thank you for this</P> Tue, 16 Apr 2024 07:17:02 GMT https://community.fabric.microsoft.com/t5/Desktop/New-to-power-bi-and-need-help-with-measures/m-p/3840272#M1239275 pb14 2024-04-16T07:17:02Z