topic Total of average amount impact not working in Desktop
https://community.powerbi.com/t5/Desktop/Total-of-average-amount-impact-not-working/m-p/1684632#M670700
<TABLE border="1"><TBODY><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Year</TD><TD>Product</TD><TD>ProdSubCat</TD><TD>Pricecurryr</TD><TD>priceprvyr</TD><TD>qty</TD><TD>price</TD><TD>pricediff</TD><TD>afftectedamt</TD></TR><TR><TD>2020</TD><TD>11</TD><TD>12</TD><TD>2.20</TD><TD>2.10</TD><TD>1</TD><TD>2.20</TD><TD>.10</TD><TD>.10</TD></TR><TR><TD>2019</TD><TD>11</TD><TD>12</TD><TD>2.10</TD><TD>2.10</TD><TD>1</TD><TD>2.10</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2020</TD><TD>11</TD><TD>14</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2019</TD><TD>11</TD><TD>14</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2019</TD><TD>11</TD><TD>15</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>0</TD><TD>0</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>Total</TD><TD>8.10</TD></TR></TBODY></TABLE><P> </P><P>measure =(Pricecurryr-priceprvyr)*qty</P><P>Pricecurryr,priceprvyr and qty are other measures refered in above measure.</P><P> </P>Tue, 23 Feb 2021 21:03:12 GMTsneevand2021-02-23T21:03:12ZTotal of average amount impact not working
https://community.powerbi.com/t5/Desktop/Total-of-average-amount-impact-not-working/m-p/1684632#M670700
<TABLE border="1"><TBODY><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Year</TD><TD>Product</TD><TD>ProdSubCat</TD><TD>Pricecurryr</TD><TD>priceprvyr</TD><TD>qty</TD><TD>price</TD><TD>pricediff</TD><TD>afftectedamt</TD></TR><TR><TD>2020</TD><TD>11</TD><TD>12</TD><TD>2.20</TD><TD>2.10</TD><TD>1</TD><TD>2.20</TD><TD>.10</TD><TD>.10</TD></TR><TR><TD>2019</TD><TD>11</TD><TD>12</TD><TD>2.10</TD><TD>2.10</TD><TD>1</TD><TD>2.10</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2020</TD><TD>11</TD><TD>14</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2019</TD><TD>11</TD><TD>14</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2019</TD><TD>11</TD><TD>15</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>0</TD><TD>0</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>Total</TD><TD>8.10</TD></TR></TBODY></TABLE><P> </P><P>measure =(Pricecurryr-priceprvyr)*qty</P><P>Pricecurryr,priceprvyr and qty are other measures refered in above measure.</P><P> </P>Tue, 23 Feb 2021 21:03:12 GMThttps://community.powerbi.com/t5/Desktop/Total-of-average-amount-impact-not-working/m-p/1684632#M670700sneevand2021-02-23T21:03:12ZRe: Total of average amount impact not working
https://community.powerbi.com/t5/Desktop/Total-of-average-amount-impact-not-working/m-p/1685168#M670820
<P><LI-USER uid="283402"></LI-USER> , Try a measure with one of the two options</P>
<P> </P>
<P>Averagex(Table,([Pricecurryr]-[priceprvyr])*[qty])</P>
<P> </P>
<P>Divide(Sumx(Table,([Pricecurryr]-[priceprvyr])*[qty]), Sum(Table[Qty])</P>Wed, 24 Feb 2021 03:00:24 GMThttps://community.powerbi.com/t5/Desktop/Total-of-average-amount-impact-not-working/m-p/1685168#M670820amitchandak2021-02-24T03:00:24ZRe: Total of average amount impact not working
https://community.powerbi.com/t5/Desktop/Total-of-average-amount-impact-not-working/m-p/1691041#M672316
<P>Hi <LI-USER uid="283402"></LI-USER> ,</P><P> </P><P>Be aware that DAX measure are based on row context.</P><P>You could try to create a measure like this:</P><LI-CODE lang="markup">Measure = AVERAGEX(VALUES(TABLE[YEAR]),([Pricecurryr]-[priceprvyr])*[qty])</LI-CODE><P>If the problem persists,could you share the sample pbix via cloud service like onedrive for business or paste the fact table data?</P><P> </P><P>Best Regards,<BR />Liang<BR />If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P>Fri, 26 Feb 2021 05:22:00 GMThttps://community.powerbi.com/t5/Desktop/Total-of-average-amount-impact-not-working/m-p/1691041#M672316V-lianl-msft2021-02-26T05:22:00Z