topic Re: Calculate the sum of the top 80% in DAX Commands and Tips
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763398#M3296
<P>Thank you very much, it's working fine</P>Sat, 10 Aug 2019 14:13:55 GMTimbrg2019-08-10T14:13:55ZCalculate the sum of the top 80%
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763156#M3275
<P>Dear All,</P><P>I have the attached list of accounts with the related sales and cost. </P><P>I calculate the GM for each of them</P><P>I need to calculate</P><UL><LI>The sum of the top GM of account that is making 80% of the total GM. which means I need to order GM by order of importance them make the sum of the top one until I reach 80% of total GM</LI><LI>I need to know what was the number of acount that was included in this sum to be able to calculate the average GM</LI></UL><P>can you please support</P><P> </P><P>Regards,</P><P>imed</P><P> </P><P> <A title="example" href="https://laurentide0-my.sharepoint.com/:x:/g/personal/ibourega_laurentide_com/EcHruMd6zxJAu_nEpFWTPZcBtCqRBqW2Lu3-f4KMg3wtyw?e=qX7j46" target="_self">Example file</A></P>Fri, 09 Aug 2019 18:45:17 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763156#M3275imbrg2019-08-09T18:45:17ZRe: Calculate the sum of the top 80%
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763253#M3281
<P><A href="https://1drv.ms/u/s!ApyQEauTSLtO6nLnM15GAnkE2cqN?e=SJxSGi" target="_self">PBIX file on my OneDrive</A></P><P> </P><P>Best</P><P>Darek</P>Fri, 09 Aug 2019 22:13:47 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763253#M3281Anonymous2019-08-09T22:13:47ZRe: Calculate the sum of the top 80%
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763287#M3287
<P>Thanks Darek for the solutions</P><P>May I ask one more thing?</P><P>I need to calculate the average of the GM for the accounts that we have included in the calculation of the 80% of GM</P><P> </P><P>can you please support</P><P> </P><P>regards,</P><P>Imed</P>Sat, 10 Aug 2019 01:11:09 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763287#M3287imbrg2019-08-10T01:11:09ZRe: Calculate the sum of the top 80%
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763393#M3294
Just create a measure: DIVIDE( [Total GM (80% Top Cust)], [Count of Cust (80% Top Cust)]).<BR /><BR />Best<BR />DarekSat, 10 Aug 2019 13:59:10 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763393#M3294Anonymous2019-08-10T13:59:10ZRe: Calculate the sum of the top 80%
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763398#M3296
<P>Thank you very much, it's working fine</P>Sat, 10 Aug 2019 14:13:55 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763398#M3296imbrg2019-08-10T14:13:55ZRe: Calculate the sum of the top 80%
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763527#M3302
<P>Hello Darek</P><P>The calculation are working fine however when I use the measure with other fields some a dim table it's not working anymore</P><P>can you please support</P><P> </P><P>regards</P><P>Imed</P>Sun, 11 Aug 2019 12:16:20 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763527#M3302imbrg2019-08-11T12:16:20ZRe: Calculate the sum of the top 80%
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763528#M3303
<P>I think the utilisation of addcolumns in the measure is the one causing this issue.</P><P> </P><P>thanks you for your support</P><P> </P><P>Regards</P><P>imed</P>Sun, 11 Aug 2019 12:24:48 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/m-p/763528#M3303imbrg2019-08-11T12:24:48Z