Forum Discussion

dmbd1904's avatar
dmbd1904
Helper III
5 years ago
Solved

Aggregated Averages

Hi, I'm having a lot of trouble with these measures.   Basically the measures are calculating the averages correctly at the row level, but not at the aggreagated 'Total'.   Inflated Base Rate / ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi dmbd1904 ,

     

    Try to use below measures instead:

    Inflated Base Rate_ave=Averagex(values(Index),[Inflated Base Rate/Unit(Ave.)])
    Inflated Coverted_ave=Averagex(values(Index),[Inflated Converted(Ave.)])

     

    If the above measure still dont work out,pls upload your .pbix file to onedrive business and share the link with us,remember to remove the confidential information.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi dmbd1904 ,

 

Try to use below measures instead:

Inflated Base Rate_ave=Averagex(values(Index),[Inflated Base Rate/Unit(Ave.)])
Inflated Coverted_ave=Averagex(values(Index),[Inflated Converted(Ave.)])

 

If the above measure still dont work out,pls upload your .pbix file to onedrive business and share the link with us,remember to remove the confidential information.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!