Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Summarize Calc

This should be an easy question but I am trying to run an average price calculation at the Item level within my table.

 

I am using this calculation

Current Avg Price =
SUMX(
SUMMARIZE('Current Variance','Current Variance'[item],"Cur Avg Price",[Avg Price]),[Cur Avg Price])
 
 

 

 

Which gives me the right data however when I pull the item filter off that chart everything disappears when in theory it should give me a summation of all of the items average price.

 

I tried this but it says its the incorrect parameter type:

 

Current Avg Price =
SUMX(
SUMMARIZE('Current Variance','Current Variance'[item],"Cur Avg Price",[Avg Price],ALL('Current Variance'[item])),[Cur Avg Price])
Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Also if anyone knows how to run the equation SUM(Ext Price)/SUM(Volume) within that calculation instead of the calculated Avg Price I had to make that would be even better!

     

    I got the calculation working however the totals are wrong. Is there a way to get an accurate SUM when using a SUMX calculation:

     

    Current Avg Price =
    SUMX(
    SUMMARIZE('Current Variance','Current Variance'[item],
    "Cur Avg Price",[Avg Price]),[Cur Avg Price])
     
    Previous Avg Price =
    SUMX(
    SUMMARIZE('Previous Variance','Previous Variance'[item],
    "Prev Avg Price",[Prev Avg Price]),[Prev Avg Price])
     
    Current Vol =
    SUMX(
    SUMMARIZE('Current Variance','Current Variance'[item],
    "Cur Avg Vol",SUM('Current Variance'[volume])),[Cur Avg Vol])

     

    Price Variance = ('Current Variance'[Current Avg Price]-'Previous Variance'[Previous Avg Price])*'Current Variance'[Current Vol]
     

     

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Your question is not clear.  Share some data, describe your question and clearly show the result in a simple Table format.  The link you shared is not working.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

    It seems that I don't have access to your sample from your link. Please share a sample with me from your Onedrive for Business. And your logic si complex, could you show me the result you want? This will make it easier for me to understand your requirement.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.