Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average Sales per Unit per Day

Have anyone found an effective way to calculate the Average per Units per Day in Power BI.  I tried the following 2 steps approach unsuccessfully:  Per Unit Average Calculation Average per Unit =...
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , Anonymous 

    According to your description, you calculate the average of different logics and look like a measure.
    The calculation of the measure is directly related to the field you put above the visual. We cann see that you are using the  VALUES() function, which will only get the value of your current row. If you want to filter the entire table with the same Unit, you need to replace your function and use the FILTER() and ALLSELECTED() functions to find the value you need to average.

     

    If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello tamerj1 - Thank you for your reply. I did try this formula; however, it did not work.

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous 

This is basically the same as youtr formula but using one measure 

Average per Unit per day =
AVERAGEX (
VALUES ( 'TABLE NAME'[Days] ),
CALCULATE ( AVERAGEX ( VALUES ( 'TABLE NAME'[Units] ), [Total Sales] ) )
)